On 9th of January 2023, Tom Lane committed patch: Invent random_normal() to provide normally-distributed random numbers. There is already a version of this in contrib/tablefunc, but it seems sufficiently widely useful to justify having it in core. Paul Ramsey Discussion: https://postgr.es/m/CACowWR0DqHAvOKUCNxTrASFkWsDLqKMd6WiXvVvaWg4pV1BMnQ@mail.gmail.com
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”
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 17 … PostgreSQL 16 … PostgreSQL 15 … PostgreSQL 14 … PostgreSQL 13 … PostgreSQL … Continue reading “Waiting for …”
On 21st of March, Robert Haas committed patch: Support parallel aggregation. Parallel workers can now partially aggregate the data and pass the transition values back to the leader, which can combine the partial results to produce the final answer. David Rowley, based on earlier work by Haribabu Kommi. Reviewed by Álvaro Herrera, Tomas … Continue reading “Waiting for 9.6 – Support parallel aggregation.”
On 18th of December, Teodor Sigaev committed patch: Introduce distance operators over cubes: <#> taxicab distance <-> euclidean distance <=> chebyshev distance Also add kNN support of those distances in GiST opclass. Author: Stas Kelvich
On 11th of November, Robert Haas committed patch: Generate parallel sequential scan plans in simple cases. Add a new flag, consider_parallel, to each RelOptInfo, indicating whether a plan for that relation could conceivably be run inside of a parallel worker. Right now, we’re pretty conservative: for example, it might be possible to defer applying … Continue reading “Waiting for 9.6 – Generate parallel sequential scan plans in simple cases.”
On 27th of March, Andrew Dunstan committed patch: Add stats for min, max, mean, stddev times to pg_stat_statements. The new fields are min_time, max_time, mean_time and stddev_time. Based on an original patch from Mitsumasa KONDO, modified by me. Reviewed by Petr Jelínek.
On 7th of December, Simon Riggs committed patch: Event Trigger for table_rewrite Generate a table_rewrite event when ALTER TABLE attempts to rewrite a table. Provide helper functions to identify table and reason. Intended use case is to help assess or to react to schema changes that might hold exclusive locks for long periods. … Continue reading “Waiting for 9.5 – Event Trigger for table_rewrite”
On 13th of April, Tom Lane committed patch: Provide moving-aggregate support for a bunch of numerical aggregates. First installment of the promised moving-aggregate support in built-in aggregates: count(), sum(), avg(), stddev() and variance() for assorted datatypes, though not for float4/float8. In passing, remove a 2001-vintage kluge in interval_accum(): interval array elements have been … Continue reading “Waiting for 9.4 – Provide moving-aggregate support for a bunch of aggregates.”
On 29th of January, Andrew Dunstan committed patch: Add json_array_elements_text function. This was a notable omission from the json functions added in 9.3 and there have been numerous complaints about its absence. Laurence Rowe.