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.htmlOut of interested, in what context did you want compression?Ron Mayer <rm_pg@cheapcomplexdevices.com>
Sent by: pgsql-general-owner@postgresql.org27/10/2008 07:34 | To | 小波 顾 <guxiaobo1982@hotmail.com> | cc | "pgsql-general@postgresql.org" <pgsql-general@postgresql.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@postgresql.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
******************************************************************************