VACUUM at the Page Level

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

In HOT Updates in Postgres we covered page pruning clean up HOT chains, an elegant shortcut where PostgreSQL reclaims dead tuple space during ordinary reads. All that without waiting for any background process. But pruning is exactly that: a shortcut. It only works within a single page, and only for HOT-updated tuples. For everything else (cold updates that touch indexed columns, plain DELETEs,…

Read on boringsql.com ↗