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 <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 27/10/2008 07:34 To 小波 顾 <[EMAIL PROTECTED]> 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 ******************************************************************************
