PostgreSQL

The most valuable on- and offline documentation I came across during 10 years of development and PostgreSQL administration.

When using the official PostgreSQL repo this FAQ might be handy.

Table partitioning mainly used for performance reasons or easier maintenance procedures.

PgAdmin3 GUI can be used to manage PostgreSQL database instances. For most operating systems a downloadable installer is provided. Other operating systems require installation via packages. Links lead to the latest versions I’ve tried to be fully functional.

Sometimes you wonder how to gain performance by adding indexes, change tuning parameters or rewrite your queries. Before doing so, it’s wise to explain analyze queries and enable slow query logging. But sometimes you simply need some tooling, here are my picks!