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