Re: Does Postgres compress data?

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does Postgres compress data?
Date: 2012-05-24 01:16:55
Message-ID: 1337822215.74161.YahooMailNeo@web46110.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike --

<...>

>
>Is PG compressing this data?  I'm curious as I was considering
>converting this column to a byte array and gzip'ing the data to save
>space, however if PG is already doing this for me, then I'm not going
>to bother.  Thanks!
>
>Mike

It may vary from version of postgres to version, but perhaps you are seeing the effects of TOAST kicking in ? Do a search in the documentation for your specific version (8.3, 9.1 etc.)

HTH,

Greg Williamson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2012-05-24 01:23:13 Re: Does Postgres compress data?
Previous Message Adrian Klaver 2012-05-24 01:11:10 Re: Does Postgres compress data?