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

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

On 22nd of March, Tom Lane committed patch: Allow foreign tables to participate in inheritance. Foreign tables can now be inheritance children, or parents. Much of the system was already ready for this, but we had to fix a few things of course, ...

( title, in case you don't know, comes from excellent "movie" about databases ) The secret ingredient is of course sharding. Can we do sharding in PostgreSQL? First, let's define what sharding is: