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 there is only ~ 270,000 plans – the reason is very simple. Splitting the data into multiple tables makes maintenance tasks (vacuum, dump) much simpler and easier.
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 to explain, to my best knowledge, what it is, why one would want to use it, and how to actually make it happen.
Continue reading Partitioning – what? why? how?