| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Yang Zhang <yanghatespam(at)gmail(dot)com> |
| Subject: | Re: Compression |
| Date: | 2011-04-15 04:37:10 |
| Message-ID: | 4DA7CB76.2050208@postnewspapers.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 15/04/2011 8:07 AM, Adrian Klaver wrote:
> "EXTENDED allows both compression and out-of-line storage. This is the
> default for most TOAST-able data types. Compression will be attempted
> first, then out-of-
>
> line storage if the row is still too big. "
Good point. I was unclear; thanks for pointing it out.
What I was trying to say is that there's no whole-row compression, ie
compression of the whole tuple except for minimal headers. A value in a
field may be compressed, but you can't (say) compress a 100-column row
of integers in Pg, because the individual fields don't support compression.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Basil Bourque | 2011-04-15 05:20:00 | Re: UUID can be written to row when passed as parameter/argument to a PL/pgSQL function. Feature or bug? |
| Previous Message | Yang Zhang | 2011-04-15 04:16:35 | Re: Compression |