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 ...

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

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 ...

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

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.

RETURN with an expression terminates the function and returns the value of expression to the caller. This form is used for PL/pgSQL functions that do not return a set. In a function that returns a ...

<= less than or equal ARRAY[1,2,3] <= ARRAY[1,2,3] t See Section 8.15 for more details about array operator behavior. See Section 11.2 for more details about which operators support indexed operations ...

pg_basebackup is used to take base backups of a running PostgreSQL database cluster. These are taken without affecting other clients to the database, and can be used both for point-in-time recovery ...

If you have pattern matching needs that go beyond this, consider writing a user-defined function in Perl or Tcl. While most regular-expression searches can be executed very quickly, regular ...