News for hackers. Stuff that matters.
Re:PostgreSQL 16 Released by paulddraper on Thursday September 14, 2023 @02:40PM (#37512985)
> What's the use case where data shrinks ?

Parent literally provided one: deleting a column.

Another is that it's very easy in PostgreSQL to bloat indexes. Load a bunch of data. Update (or delete) that data and now your index is bloated.

The only resolution is to REINDEX (or VACUUM FULL).

Re:PostgreSQL 16 Released by efxhoy on Thursday September 14, 2023 @05:30PM (#37515116)
The nice thing about index bloat is REINDEX has a CONCURRENTLY option, no need to block writes.
Re:PostgreSQL 16 Released by paulddraper on Thursday September 14, 2023 @11:50PM (#37518125)
True, good point.