| From: | Mike Christensen <mike(at)kitchenpc(dot)com> |
|---|---|
| To: | Greg Williamson <gwilliamson39(at)yahoo(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Does Postgres compress data? |
| Date: | 2012-05-24 01:23:13 |
| Message-ID: | CABs1bs1miS8xMiYQ4ttP8zcpwWJsvv-h3s-8nUGfhxU08DrTwA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, May 23, 2012 at 6:16 PM, Greg Williamson
<gwilliamson39(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2012-05-24 07:21:28 | Re: Up-to-date reports database |
| Previous Message | Greg Williamson | 2012-05-24 01:16:55 | Re: Does Postgres compress data? |