3 ms·
For a log table or anything immutable and write heavy, definitely. That being said it might be difficult to know when you won't get any benefit out of it unles
by saosebastiao 11y ago
For a log table or anything immutable and write heavy, definitely.
That being said it might be difficult to know when you won't get any benefit out of it unless you have control or knowledge of how rows are laid out in the table space. For example, deleting some rows based off of a fairly random criteria may make Postgres insert into those spaces on subsequent writes (after a vacuum), which could "pollute" the block ranges with non-ordinal data and make the block ranges less targeted.