Re: Does Postgres compress data? - Mailing list pgsql-general

From Mike Christensen
Subject Re: Does Postgres compress data?
Date
Msg-id CABs1bs1miS8xMiYQ4ttP8zcpwWJsvv-h3s-8nUGfhxU08DrTwA@mail.gmail.com
Whole thread Raw
In response to Re: Does Postgres compress data?  (Greg Williamson <gwilliamson39@yahoo.com>)
List pgsql-general
On Wed, May 23, 2012 at 6:16 PM, Greg Williamson
<gwilliamson39@yahoo.com> wrote:
> 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
searchin the documentation for your specific version (8.3, 9.1 etc.) 

Yup, looks like this is the default behavior for TOAST-able columns.
I'm running on 9.0.  Anyway, good information - I was mostly just
curious..

Mike

pgsql-general by date:

Previous
From: Greg Williamson
Date:
Subject: Re: Does Postgres compress data?
Next
From: Gavin Flower
Date:
Subject: Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1