From: | Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: tuple data size and compression |
Date: | 2016-12-15 16:26:45 |
Message-ID: | CAK77FCTsSjNynyiWWoZA8CyPVFYRrEfGda5mHkEYWhLf2GLYdQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> https://www.postgresql.org/docs/9.5/static/storage-toast.html
>>
>
> "The TOAST management code is triggered only when a row value to be stored
> in a table is wider than TOAST_TUPLE_THRESHOLD bytes (normally 2 kB). The
> TOAST code will compress and/or move field values out-of-line until the row
> value is shorter than TOAST_TUPLE_TARGET bytes (also normally 2 kB) or no
> more gains can be had. During an UPDATE operation, values of unchanged
> fields are normally preserved as-is; so an UPDATE of a row with out-of-line
> values incurs no TOAST costs if none of the out-of-line values change."
>
> Pupillo
>>
> --
>>
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
I see. But in my case rows don't reach that thresold (I didn't check if 2K
but I didn't change anything). So I'm wondering if there is any other
chance except the TOAST to get the rows compressed or not.
I noticed that, when I use constant data, the total IO writes (by iostat)
are more or less 1/2 of the the total IO writes when using random or other
data hard to compress.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Devoy | 2016-12-15 16:32:00 | Re: CRM where pg is a first class citizen? |
Previous Message | Thomas Kellerer | 2016-12-15 16:15:44 | Re: pg_dump and quoted identifiers |