This message is being sent from the Community Code of Conduct Committee, with the approval of the Core Team. As ...

Hello, Greetings from India PostgreSQL User Group! We are pleased to announce that **PGConf India 2025** will be held in ...

Nordic PGDay will once again return to Copenhagen for a day of PostgreSQL by the sea on March 18 2025. Nordic PGDay is a one-day single track event (with an adjoining sponsor track) focusing on ...

The PoWA team is pleased to announce the release of the version 2.3.0 ofpg_stat_kcache, an extension that gathers statistics about real reads and writes done by the ...

The pgmoneta community is happy to announce version 0.14.0.

We are very glad to announce the 4.5.0 version of E-Maj. E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database. This version brings the ...

ALTER TABLE changes the definition of an existing table. There are several subforms described below. Note that the lock level required may differ for each subform. An ACCESS EXCLUSIVE lock is acquired ...

pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/restore ...

This section describes the SQL-compliant conditional expressions available in PostgreSQL. Tip: If your needs go beyond the capabilities of these conditional expressions, you might want to consider ...

ALTER LARGE OBJECT — change the definition of a large object ALTER MATERIALIZED VIEW — change the definition of a materialized view ALTER OPERATOR — change the definition of an operator ALTER OPERATOR ...

PostgreSQL provides various lock modes to control concurrent access to data in tables. These modes can be used for application-controlled locking in situations where MVCC does not give the desired ...

When logging_collector is enabled, this parameter sets the file names of the created log files. The value is treated as a strftime pattern, so %-escapes can be used to specify time-varying file names.