On 22nd of January, Tom Lane committed patch: Add trigonometric functions that work in degrees. The implementations go to some lengths to deliver exact results for values where an exact result can be expected, such as sind(30) = 0.5 exactly. Dean Rasheed, reviewed by ...

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: Allow to omit boundaries in array subscript Allow to omiy lower or upper or both boundaries in array subscript for selecting slice of array. Author: YUriy Zhuravlev

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 9th of December, Robert Haas committed patch: Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistics. The original parallel sequential scan commit included only very limited changes to the EXPLAIN output. Aggregated totals from all workers were displayed, but there was no way ...

On 8th of December, Robert Haas committed patch: psql: Support multiple -c and -f options, and allow mixing them. To support this, we must reconcile some historical anomalies in the behavior of -c. In particular, as a backward-incompatibility, -c no longer implies --no-psqlrc. Pavel ...

Someone asked today on irc about grouping data, that contains timestamps, into "partitions". Usually when someone wants something like this, you can do grouping by date_trunc(), but this time, this person, wanted to group data that all timestamps are within given ...

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 30th of October, Tom Lane committed patch: Implement lookbehind constraints in our regular-expression engine. A lookbehind constraint is like a lookahead constraint in that it consumes no text; but it checks for existence (or nonexistence) of a match *ending* at the current point ...

Some time ago, guys from Instagram shared their approach to generating unique ids on multiple hosts in a way that guarantees (to reasonable extend) uniqueness, and doesn't require any centralized service. Earlier this month, the build benchmarked their solution vs. UUIDs, ...