On Wed, May 23, 2012 at 6:16 PM, Greg Williamson <gwilliamso...@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 search in 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
