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

On 7th of April 2018, Alvaro Herrera committed patch: Support partition pruning at execution time Existing partition pruning is only able to work at plan time, for query quals that appear in the parsed query. This is good but limiting, as there can ...

On 28th of March 2018, Andrew Dunstan committed patch: Fast ALTER TABLE ADD COLUMN with a non-NULL default Currently adding a column to a table with a non-NULL default results in a rewrite of the table. For large tables this can be both ...

Support parallel btree index builds. To make this work, tuplesort.c and logtape.c must also support parallelism, so this patch adds that infrastructure and then applies it to the particular case of parallel btree index builds. Testing to date shows that this can often ...

I missed it completely, but on 24th of March 2017, Alvaro Herrera committed patch: Implement multivariate n-distinct coefficients Add support for explicitly declared statistic objects (CREATE STATISTICS), allowing collection of statistics on more complex combinations that individual table columns. Companion commands DROP STATISTICS and ...

Lately at least two people on irc asked questions similar to "how do I know how many queries there are in database, per second?". So, let's see what we can find out.

On 7th of April, Teodor Sigaev committed patch: Phrase full text search. Patch introduces new text search operator (< -> or ) into tsquery. On-disk and binary in/out format of tsquery are backward compatible. It has two side effect: - change order for tsquery, so, ...

April 11th, 2016 by depesz | Tags: , , , , , | Comments Off on Waiting for 9.6 – Bloom index contrib module

On 1st of April, Teodor Sigaev committed patch: Bloom index contrib module Module provides new access method. It is actually a simple Bloom filter implemented as pgsql's index. It could give some benefits on search with large number of columns. Module is a single way ...

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

On 11th of February, Tom Lane committed patch: Remove GROUP BY columns that are functionally dependent on other columns. If a GROUP BY clause includes all columns of a non-deferred primary key, as well as other columns of the same relation, those other ...