Re: Are there plans to add data compression feature to postgresql?

Note that most data stored in the TOAST table is compressed.

IE a Text type with length greater than around 2K will be stored in the
TOAST table. By default data in the TOAST table is compressed, this can
be overriden.

However I expect that compression will reduce the performance of certain
queries.

http://www.postgresql.org/docs/8.3/interactive/storage-toast.html

Out of interested, in what context did you want compression?

Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Sent by: pgsql-general-owner(at)postgresql(dot)org
27/10/2008 07:34

To
小波 顾 <guxiaobo1982(at)hotmail(dot)com>
cc
"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject
Re: [GENERAL] Are there plans to add data compression feature to
postgresql?

You might want to try using a file system (ZFS, NTFS) that
does compression, depending on what you're trying to compress.

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

******************************************************************************
If you are not the intended recipient of this email please do not send it on
to others, open any attachments or file the email locally.
Please inform the sender of the error and then delete the original email.
For more information, please refer to http://www.shropshire.gov.uk/privacy.nsf
******************************************************************************