News for hackers. Stuff that matters.
Re:PostgreSQL 16 Released by adql on Thursday September 14, 2023 @01:55PM (#37512404)
...okay ? What's the use case where data shrinks ?

The data that will be "not removed" will just be used by new data.

Only real use case is "we've loaded way too many data, removed it, and want to recover that space because we will never need it", and that is not enough to matter, as usually database have its own filesystem and most filesystems can't be shrunk online so any shrinking needs downtime

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.