Composite types in PostgreSQL: (func()).* - Hidden performance issues
Using composite types offers db developers a great deal of flexibility. Passing complex data to functions is a lot easier.
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.
Walbouncer update - a proxy for selective PostgreSQL physical replication
walbouncer update, now supporting PostgreSQL 14, together with a helper script to build replicas. How-to on the walbouncer set up process.
