On Wed, Mar 24, 2021 at 2:15 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > But let's ignore the case of pg_upgrade and just consider a dump/restore. > I'd still say that unless you give --no-toast-compression then I would > expect the dump/restore to preserve the tables' old compression behavior. > Robert's argument that the pre-v14 database had no particular compression > behavior seems nonsensical to me. We know exactly which compression > behavior it has.
I said that it didn't have a state, not that it didn't have a behavior. That's not exactly the same thing. But I don't want to argue about it, either. It's a judgement call what's best here, and I don't pretend to have all the answers. If you're sure you've got it right ... great! -- Robert Haas EDB: http://www.enterprisedb.com
