Month: November 2017
Using “lightweight” functional indexes – BRIN
By Kaarel Moppel – Using BRIN to improve query performance – This is a quick performance tip for all those wrestling with occasional slow 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 […]
How we built our cluster in a box
During this year’s pgconf.eu we displayed a “cluster in a box” demo case with Patroni. 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 […]
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 […]