Re: Compressed binary field - Mailing list pgsql-general

From Tom Lane
Subject Re: Compressed binary field
Date
Msg-id 27735.1347302137@sss.pgh.pa.us
Whole thread Raw
In response to Compressed binary field  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Compressed binary field  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
Edson Richter <edsonrichter@hotmail.com> writes:
> I would like to know if there is any plan to implement compressed fields
> (just a "flag" in the field definition, like "not null") at database
> side (these fields are and will never be indexed neither used for search).

Any field value over a couple kilobytes is compressed automatically;
this has been true for more than a dozen years.  You can turn that
off if you want, but it's done by default.

http://www.postgresql.org/docs/9.1/static/storage-toast.html

            regards, tom lane


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Compressed binary field
Next
From: Edson Richter
Date:
Subject: Re: Compressed binary field