PostgreSQL: Indexes and foreign keys
Missing indexes and foreign keys may cause database performance problems. Learn how to speed up things dramatically - not only in PostgreSQL!
Why favor PostgreSQL over MariaDB / MySQL
For many years MySQL and PostgreSQL were competing databases, which addressed slightly different audiences. Why you should go for PostgreSQL!
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.
Removing duplicate rows in PostgreSQL
What if you accidently load data twice? How can developers handle duplicate data and cleanup things? | Removing duplicate rows.
Experimenting with scaling and full parallelism in PostgreSQL
How-to about scaling PostgreSQL to one billion rows per second. We show you hands-on how to get the most out of your PostgreSQL server farms.
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.
Detecting unstable execution times in PostgreSQL
How to tune a query which is sometimes slow and sometimes fast. The question is usually: How come it has an unstable execution time?
pg_basebackup: Creating self-sufficient backups
UPDATED Aug 2023 How to use pg_basebackup: allows users to create a binary copy of their data, which is the basis for Point-In-Time-Recovery.
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 […]
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.
