Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.

On 16th of February 2019, Tom Lane committed patch: Allow user control of CTE materialization, and change the default behavior.   Historically we’ve always materialized the full output of a CTE query, treating WITH as an optimization fence (so that, for example, restrictions from the outer query cannot be pushed into it). This is appropriate … Continue reading “Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.”

Waiting for PostgreSQL 12 – Allow COPY FROM to filter data using WHERE conditions

On 19th of January 2019, Tomas Vondra committed patch: Allow COPY FROM to filter data using WHERE conditions   Extends the COPY FROM command with a WHERE condition, which allows doing various types of filtering while importing the data (random sampling, condition on a data column, etc.). Until now such filtering required either preprocessing of … Continue reading “Waiting for PostgreSQL 12 – Allow COPY FROM to filter data using WHERE conditions”

Waiting for PostgreSQL 12 – Add log_statement_sample_rate parameter

On 29th of November 2018, Alvaro Herrera committed patch: Add log_statement_sample_rate parameter   This allows to set a lower log_min_duration_statement value without incurring excessive log traffic (which reduces performance). This can be useful to analyze workloads with lots of short queries.   Author: Adrien Nayrat   Discussion: https://postgr.es/m/-ee1e-db9f-fa97-@anayrat.info

Waiting for PostgreSQL 12 – Add CSV table output mode in psql.

On 26th of November 2018, Tom Lane committed patch: Add CSV table output mode in psql.   "\pset format csv", or –csv, selects comma-separated values table format. This is compliant with RFC 4180, except that we aren’t too picky about whether the record separator is LF or CRLF; also, the user may choose a field … Continue reading “Waiting for PostgreSQL 12 – Add CSV table output mode in psql.”

Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conf

On 25th of November 2018, Peter Eisentraut committed patch: Integrate recovery.conf into postgresql.conf   recovery.conf settings are now set in postgresql.conf (or other GUC sources). Currently, all the affected settings are PGC_POSTMASTER; this could be refined in the future case by case.   Recovery is now initiated by a file recovery.signal. Standby mode is initiated … Continue reading “Waiting for PostgreSQL 12 – Integrate recovery.conf into postgresql.conf”

Waiting for PostgreSQL 12 – Add pg_partition_tree to display information about partitions

On 30th of October 2018, Michael Paquier committed patch: Add pg_partition_tree to display information about partitions     This new function is useful to display a full tree of partitions with a partitioned table given in output, and avoids the need of any complex WITH RECURSIVE query when looking at partition trees which are deep … Continue reading “Waiting for PostgreSQL 12 – Add pg_partition_tree to display information about partitions”

Waiting for PostgreSQL 12 – Add pg_promote function

On 25th of October 2018, Michael Paquier committed patch: Add pg_promote function     This function is able to promote a standby with this new SQL-callable function. Execution access can be granted to non-superusers so that failover tools can observe the principle of least privilege.   Catalog version is bumped.   Author: Laurenz Albe   … Continue reading “Waiting for PostgreSQL 12 – Add pg_promote function”

Waiting for …

Since February of 2008 I am writing series of blogposts that hilight some of the features that get committed to PostgreSQL source, to be available in next released version. These are all of these series, Waiting for … … PostgreSQL 13 … PostgreSQL 12 … PostgreSQL 11 … PostgreSQL 10 … PostgreSQL 9.6 … PostgreSQL … Continue reading “Waiting for …”

Waiting for PostgreSQL 12 – Allow multi-inserts during COPY into a partitioned table

On 1st of August 2018, Peter Eisentraut committed patch: Allow multi-inserts during COPY into a partitioned table     CopyFrom allows multi-inserts to be used for non-partitioned tables, but this was disabled for partitioned tables. The reason for this appeared to be that the tuple may not belong to the same partition as the previous … Continue reading “Waiting for PostgreSQL 12 – Allow multi-inserts during COPY into a partitioned table”

Waiting for PostgreSQL 11 – Improve run-time partition pruning to handle any stable expression.

On 10th of June 2018, Tom Lane committed patch: Improve run-time partition pruning to handle any stable expression.     The initial coding of the run-time-pruning feature only coped with cases where the partition key(s) are compared to Params. That is a bit silly; we can allow it to work with any non-Var-containing stable expression, … Continue reading “Waiting for PostgreSQL 11 – Improve run-time partition pruning to handle any stable expression.”