Re: Does Postgres compress data?

Поиск
Список
Период
Сортировка
Искать
От
Greg Williamson
Тема
Re: Does Postgres compress data?
Дата
в 22:18:21
Msg-id
1337822215.74161.YahooMailNeo@web46110.mail.sp1.yahoo.com
Ответ на
Does Postgres compress data? (Mike Christensen)
Список
Дерево обсуждения
Does Postgres compress data? Mike Christensen <mike@kitchenpc.com>
Re: Does Postgres compress data? Greg Williamson <gwilliamson39@yahoo.com>
Re: Does Postgres compress data? Mike Christensen <mike@kitchenpc.com>
Re: Does Postgres compress data? Adrian Klaver <adrian.klaver@gmail.com>
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

В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
От: Mike Christensen
Дата:
FAQ