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

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 19th of January 2018, Robert Haas committed patch: Allow UPDATE to move rows between partitions. When an UPDATE causes a row to no longer match the partition constraint, try to move it to a different partition where it does match the partition constraint. ...

On 9th of November 2017, Robert Haas committed patch: Add hash partitioning. Hash partitioning is useful when you want to partition a growing data set evenly. This can be useful to keep table sizes reasonable, which makes maintenance operations such as VACUUM faster, ...

I had two month delay related to some work, but now I can finally write about: On 7th of December, Robert Haas committed patch: Implement table partitioning. Table partitioning is like table inheritance and reuses much of the existing infrastructure, but there are some ...

As of now, main table that stores explain.depesz.com plans is partitioned. This shouldn't be, at all, visible for users of the site, but if it would, please let me know (on irc, or via email). In case you're wondering why, after all ...

Recently I noticed that more and more cases that I deal with could use some partitioning. And while theoretically most people know about it, it's definitely not a very well-understood feature, and sometimes people are scared of it. So, I'll try ...