Checkpoint distance and amount of WAL
Tuning the database server affects the amount of WAL written to disk. Fewer checkpoints are a good idea for bigger databases.
Trying out Postgres Bloom indexes
Let's set up a simple demo to exemplify “fields of application” for Bloom and to also gauge pros/cons/performance in comparison to B-tree.
So what are Bloom indexes for Postgres?
Overview of the Bloom index in PostgreSQL. It's a very useful index method - find out how to use it & how it affects performance.
Parallel queries and SERIALIZABLE transactions
In version 9.6 PostgreSQL introduced parallel queries. The ability to use more than just one CPU core per query is […]
Introducing pg_squeeze - a PostgreSQL extension to auto-rebuild bloated tables
pg_squeeze is a PostgreSQL extension implementing a background worker process that can monitor tables and and rebuild them automatically!
Connection pooling intro - PgBouncer and pgpool-II
Connection pooling in a Postgres context: two products stand out - PgBouncer and pgpool-II. We compared both and give you insights!
The "synchronous_commit" parameter and streaming replication
If you're not yet familiar with the "synchronous_commit" parameter, keep reading. It's one of the most important PostgreSQL parameters.
Will more disks get you better PostgreSQL performance?
Find out whether to buy more hardware to fix performance problems - which are in many cases not caused by bad disk performance.
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.
