Faceting large result sets in PostgreSQL
While the term faceting may sound foreign to you, you almost certainly have run into it in your adventures online. It is those helpful little boxes that turn up when browsing in web shops or searching in catalogs, telling how to further narrow down the search results, (for example, by color) and how many items […]
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 […]
Forking databases – the art of copying without copying
I received a question about how to fork PostgreSQL databases like you can do on Heroku. As I did not find any good examples on how to do this I decided to do a quick write up. Forking a database means taking a copy of a database where you can make changes that don’t affect […]