pg_timetable v5.3 is out!
Our team is proud to introduce a new pg_timetable v5.3 release! This time we focused solely on implementing new features […]
zheap: Reinvented PostgreSQL storage
zheap is a way to keep table bloat under control by implementing a storage engine capable of running UPDATE-intense workloads a lot more efficiently.
"LOCK TABLE" can harm your database's health
by
Laurenz Albe |
03.2019 Many people know that explicit table locks with LOCK TABLE are bad style and usually a consequence of bad […]
idle_in_transaction_session_timeout: Terminating idle transactions in PostgreSQL
Long PostgreSQL transactions can cause table bloat. idle_in_transaction_session_timeout limits the duration of a transaction to prevent bloat
Four reasons why VACUUM won't remove dead rows from a table
by
Laurenz Albe |
03.2018Why vacuum? Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid […]
How a bad network configuration can cause table bloat
by
Laurenz Albe |
01.2018(Updated 2023-04-20) I recently had an interesting support case with table bloat that shows how the cause of a problem […]
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!
Estimating table bloat in PostgreSQL
A short how to on quickly spotting bloated PostgreSQL tables - 2 different methods. We also show how to artificially generate table bloat.
Detecting table bloat in PostgreSQL
If your PostgreSQL database is badly structured, you might face some table bloat. Figure out if a table is bloated or not.
