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.
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.
