Insert-only data modeling with PostgreSQL?
Introduction to insert-only data modeling with PostgreSQL. And a test scenario for a possible use case, highlighting performance benefits
Exploding runtime: How nested loops can destroy speed
What will happen if the PostgreSQL optimizer underestimates the number of rows involved in nested loops? Includes ways to fix the problem.
Spying on slow statements with “auto_explain”
PostgreSQL "auto_explain" functionality is a useful debugging helper that many people don't know about. Describes setup and use cases.
PostgreSQL underused features - WAL compression
WAL compression is a new feature of PostgreSQL 9.5 that not many are yet aware of. This post provides a testcase highlighting the benfits.
Estimating table bloat in PostgreSQL
A short how to on quickly spotting bloated PostgreSQL tables - 2 different methods. We also show how to artificially generate table bloat.
UNIX sockets vs. localhost: PostgreSQL Performance advice
Unix sockets vs. localhost: We posted a lot of tuning advice on this blog already. Now we thought we would […]
VirtualBox vs. hardware for PostgreSQL
Is there really a performance difference in PostgreSQL on hardware and PostgreSQL on Virtualbox? Find out here.
Join pruning - Cool stuff in PostgreSQL
UPDATED 2023: Find out how the PostgreSQL optimizer decides about “join pruning”. Improve performance, provide end users with simpler plans.
Indexing Wikipedia with PostgreSQL | The goal is to see which settings are most suitable for the creation of a GIN index.
pg_stat_statements: The way I like it
Finding slow queries using the PostgreSQL extension pg_stat_statements. Improve your database performance and monitoring.
