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: