Month: August 2017
PostgreSQL Showcase project – helping newcomers to get on track with Postgres
Here’s a short one. To prepare for the upcoming training season, I thought I’ll get our little “Postgres Showcase” (GitHub project) on track. The idea is that it’s just a collection of easy to follow SQL samples moving from basics to more advanced stuff, helping to exemplify how to use PostgreSQL and to show off […]
Autovacuum wraparound protection in PostgreSQL
Autovacuum is maybe one of the most beloved, but also one of the most misunderstood features in the PostgreSQL world. Many questions reaching our PostgreSQL support team are somehow related to autovacuum or VACUUM in general. So maybe it makes sense to use this opportunity to shine some light on VACUUM and a thing called […]
Joining data from multiple Postgres databases
BY Kaarel Moppel – With the heyday of big data and people running lots of Postgres databases, sometimes one needs to join or search for data from multiple absolutely regular and independent PostgreSQL databases. (i.e., no built-in clustering extensions are in use). The goal is to present it as one logical entity. Think sales reporting […]