Minimizing tuple overhead
I hear quite often people being disappointed on how much space PostgreSQL is wasting for each row it stores. I’ll try to show here some tricks to minimize this effect, to allow more efficient storage.
Estimating Needed Memory for a Sort
Keep an eye on your PostgreSQL configuration
Have you ever wished to know what configuration changed during the last weeks, when everything was so much faster, or wanted to check what happened on your beloved cluster while you were in vacation?
How About Hypothetical Indexes ?
After so much time missing this features, HypoPG implements hypothetical indexes support for PostgreSQl, available as an extension.
Talking About OPM and PoWA at pgconf.ru
Last month, I had the chance to talk about PostgreSQL monitoring, and present some of the tools I’m working on at pgconf.ru.