Home > database >  Covert DB2 Compress adaptive to PostgreSQL
Covert DB2 Compress adaptive to PostgreSQL

Time:09-22

What will be equivalent query of below DB2 to PostgreSQL .

ALTER TABLE User.emp COMPRESS YES ADAPTIVE

CodePudding user response:

There is no equivalent. The only compression that takes place is the compression of large column values by the TOAST machinery, and that happens by default.

  • Related