tuple data size and compression

From: Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: tuple data size and compression
Date: 2016-12-15 15:17:51
Message-ID: CAK77FCSQkLCU2syCJHZPthtgYuu7LijdAE7oqghPVkXG3LOLPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
it's not clear to me when tuple data (max 1000 bytes total) get compressed
on disk and when not.
I tried with pg_column_size to find the tuple's size but I get ambiguous
results.
It seems to work but sometimes the tuples seem compressed and sometime not.
I tried both with constant data and random bytes.

Thanks
Pupillo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-12-15 15:20:26 Re: pg_dump and quoted identifiers
Previous Message Adrian Klaver 2016-12-15 14:19:06 Re: pg_dump and quoted identifiers