Month: November 2017
Using “lightweight” functional indexes for better plan estimations
This is a quick performance tip for all those wrestling with occasional un-performant queries in PostgreSQL. There’s a quite simple trick available that many people don’t know about, that can be applied at “low cost” when slow queries are caused by poor planner estimates for your filter conditions. Read on for details. The problem So, […]
How we built our cluster in a box
During this year’s pgconf.eu we displayed a “cluster in a box” demo case. Many of you inquired about how we built it, so here is a blog post with all details. The goal was to provide a hands on experience of injecting failures to a high availability cluster and to show off the resiliency and self-healing […]
pg_crash: Making database crashes great again
Some of you might have seen Kaarel Moppel’s talk about pg_crash at pgconfeu 2017 in Warsaw. However, for those who didn’t have the chance to visit this year’s European conference, I decided to come up with a little blog post introducing you to the blessings of our new module. pg_crash and what it is good […]