> I would like to see "on" to be moved to some better value (likely lz4, > like toast compression), and if some day, there is yet a better > choice, we should move it again. Yes, After PostgreSQL 19,lz4became a required dependency unless you compile it yourself with--without-lz4. In most environments,lz4is already installed, so along this code path the effective choice is essentially fixed tolz4.At cluster scale, it would make more sense to expose this parameter in the frontend as a boolean setting, rather than letting users choose from multiple compression options.
