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@xxxxxxxxxxxxxxxxxxxxxxx>
Sent by: pgsql-general-owner@xxxxxxxxxxxxxx 27/10/2008 07:34 |
|
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@xxxxxxxxxxxxxx)
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
******************************************************************************
