https://community.netapp.com/t5/ONTAP-Discussions/Postgres-Compression/m-p/462180#M45074 <P>Is anyone having luck with getting any kind of data reduction on Postgress data?&nbsp; I have many TB of postgres on C400 flash and I'm getting &lt;5% total data reduction.</P><P>&nbsp;</P><P>The DB team tells me this compresses a whole lot for backups (90TB into 6TB, something like that).&nbsp; What gives?&nbsp; How can I get that kind of compression on the back end disk?</P> Mon, 21 Jul 2025 18:33:50 GMT FredGrieco1 2025-07-21T18:33:50Z https://community.netapp.com/t5/ONTAP-Discussions/Postgres-Compression/m-p/462180#M45074 <P>Is anyone having luck with getting any kind of data reduction on Postgress data?&nbsp; I have many TB of postgres on C400 flash and I'm getting &lt;5% total data reduction.</P><P>&nbsp;</P><P>The DB team tells me this compresses a whole lot for backups (90TB into 6TB, something like that).&nbsp; What gives?&nbsp; How can I get that kind of compression on the back end disk?</P> Mon, 21 Jul 2025 18:33:50 GMT https://community.netapp.com/t5/ONTAP-Discussions/Postgres-Compression/m-p/462180#M45074 FredGrieco1 2025-07-21T18:33:50Z https://community.netapp.com/t5/ONTAP-Discussions/Postgres-Compression/m-p/462181#M45075 <P>It all depends on the data.</P><P>If the data is pre-compressed or pre-deduplicated, it will not becomre more efficient</P><P>If the data is encrypted BEFORE it gets to the storage,&nbsp;it will not becomre more efficient</P><P>The point of encryption is to remove repeatable patterns in the data, hence no dedupe/compression since they rely on pattern finding.</P> Mon, 21 Jul 2025 19:08:20 GMT https://community.netapp.com/t5/ONTAP-Discussions/Postgres-Compression/m-p/462181#M45075 TMACMD 2025-07-21T19:08:20Z