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

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

On 20th of January, Robert Haas committed patch: The core innovation of this patch is the introduction of the concept of a partial path; that is, a path which if executed in parallel will generate a subset of the output rows in each ...

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

On 2nd of September, Teodor Sigaev committed patch: Allow usage of huge maintenance_work_mem for GIN build. Currently, in-memory posting list during GIN build process is limited 1GB because of using repalloc. The patch replaces call of repalloc to repalloc_huge. It increases limit of posting ...

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.