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

From Greg Williamson
Subject Re: Does Postgres compress data?
Date
Msg-id 1337822215.74161.YahooMailNeo@web46110.mail.sp1.yahoo.com
Whole thread Raw
In response to Does Postgres compress data?  (Mike Christensen <mike@kitchenpc.com>)
Responses Re: Does Postgres compress data?
List 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
searchin the documentation for your specific version (8.3, 9.1 etc.) 

HTH,

Greg Williamson


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Does Postgres compress data?
Next
From: Mike Christensen
Date:
Subject: Re: Does Postgres compress data?