Understanding recursive queries in PostgreSQL
This article gives a simple introduction with examples to recursive queries in PostgreSQL. It also includes a comparison to Oracle recursive queries.
Binary data performance in PostgreSQL
This article discusses the question if binary data should be stored inside PostgreSQL or not. The performance of the various options is benchmarked.
PostgreSQL v13 new feature: tuning autovacuum on insert-only tables
PostgreSQL v13 introduces autovacuum for insert-only tables. This article tells you why and how to make use of this new feature.
Subtransactions and performance in PostgreSQL
The overuse of subtransactions in PostgreSQL can harm performance - find out how to diagnose if you are suffering from it.