Search Results for: waiting for 9.4

Waiting for 9.4 – Add new wal_level, logical, sufficient for logical decoding.

On 11th of December, Robert Haas committed patch: Add new wal_level, logical, sufficient for logical decoding.   When wal_level=logical, we’ll log columns from the old tuple as configured by the REPLICA IDENTITY facility added in commit <a class="text" href="/gitweb/?p=postgresql.git;a=object;h=07cacba983ef79be4a84fcd0e0ca3b5fcb85dd65">07cacba983ef79be4a84fcd0e0ca3b5fcb85dd65</a>. This makes it possible a properly-configured logical replication solution to correctly follow table updates even if … Continue reading “Waiting for 9.4 – Add new wal_level, logical, sufficient for logical decoding.”

Waiting for 9.4 – Support multi-argument UNNEST(), and TABLE() syntax for multiple functions.

On 22nd of November, Tom Lane committed patch: Support multi-argument UNNEST(), and TABLE() syntax for multiple functions.   This patch adds the ability to write TABLE( function1(), function2(), …) as a single FROM-clause entry. The result is the concatenation of the first row from each function, followed by the second row from each function, etc; … Continue reading “Waiting for 9.4 – Support multi-argument UNNEST(), and TABLE() syntax for multiple functions.”

Waiting for 9.4 – WITH CHECK OPTION support for auto-updatable VIEWs

On 18th of July, Stephen Frost committed patch: WITH CHECK OPTION support for auto-updatable VIEWs   For simple views which are automatically updatable, this patch allows the user to specify what level of checking should be done on records being inserted or updated. For ‘LOCAL CHECK’, new tuples are validated against the conditionals of the … Continue reading “Waiting for 9.4 – WITH CHECK OPTION support for auto-updatable VIEWs”

Waiting for 9.4 – Implement the FILTER clause for aggregate function calls.

On 17th of July, Noah Misch committed patch: Implement the FILTER clause for aggregate function calls.   This is SQL-standard with a few extensions, namely support for subqueries and outer references in clause expressions.   catversion bump due to change in Aggref and WindowFunc.   David Fetter, reviewed by Dean Rasheed.

Waiting for 9.4 – Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.

On 16th of July, Kevin Grittner committed patch: Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.   This allows reads to continue without any blocking while a REFRESH runs. The new data appears atomically as part of transaction commit.   Review questioned the Assert that a matview was not a system relation. This will be addressed … Continue reading “Waiting for 9.4 – Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.”

Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.

On 3rd of April 2024, Tom Lane committed patch: Invent SERIALIZE option for EXPLAIN.   EXPLAIN (ANALYZE, SERIALIZE) allows collection of statistics about the volume of data emitted by a query, as well as the time taken to convert the data to the on-the-wire format. Previously there was no way to investigate this without actually … Continue reading “Waiting for PostgreSQL 17 – Invent SERIALIZE option for EXPLAIN.”