Re: tuple data size and compression

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.

In response to

Responses

Browse pgsql-general by date

  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