Postgres Compression

[FredGrieco1]

Is anyone having luck with getting any kind of data reduction on Postgress data?  I have many TB of postgres on C400 flash and I'm getting <5% total data reduction.

The DB team tells me this compresses a whole lot for backups (90TB into 6TB, something like that).  What gives?  How can I get that kind of compression on the back end disk?

[TMACMD]

It all depends on the data.

If the data is pre-compressed or pre-deduplicated, it will not becomre more efficient

If the data is encrypted BEFORE it gets to the storage, it will not becomre more efficient

The point of encryption is to remove repeatable patterns in the data, hence no dedupe/compression since they rely on pattern finding.