Type alignment and padding bytes: how to not waste space in PostgreSQL tables
by
Laurenz Albe |
04.2025Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.
(Updated 2024-12-23) Among the many index types in PostgreSQL, the hash index is the most widely ignored. This came home […]
PostgreSQL: What is a checkpoint?
How to use checkpoints and checkpoint tuning, and how PostgreSQL writes data, database internals explained.
Insert-only data modelling to smooth peaks on slow disks
Using insert-only data modelling to smooth peaks on slow disks. Nice design trick that alleviates performance problems when used correctly
HOT updates in PostgreSQL for better performance
by
Laurenz Albe |
09.2020UPDATED blog article on 09.01.2023 HOT updates are not a new feature. They were introduced by commit 282d2a03dd in 2007 […]
Tuning max_connections in PostgreSQL
by
Laurenz Albe |
04.2020 (Updated 2023-02-22) In my daily work, I see many databases with a bad setting for max_connections. There is little […]
Speeding up GROUP BY in PostgreSQL
How to speed up GROUP BY statements in PostgreSQL. Follow some basic rules & you will squeeze performance out of the database for free.
Foreign data wrapper for PostgreSQL: Performance Tuning
fdw performance tuning - hidden tuning options which are not widely known. Let's see how to speed up the PostgreSQL foreign data wrapper.
Sort Performance in PostgreSQL
How to speed up and improve sort performance in PostgreSQL. Shows the many cases where it makes sense to avoid sorting by using indexes.
Rules or triggers to log bulk updates?
by
Laurenz Albe |
07.2018 Inspired by my co-worker's recent blog post, I decided to revisit the old question of rules vs. triggers and […]
