Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] tuple data size and compression - Mailing list pgsql-general

From Tom DalPozzo
Subject [GENERAL] tuple data size and compression
Date
Msg-id CAK77FCSQkLCU2syCJHZPthtgYuu7LijdAE7oqghPVkXG3LOLPA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] tuple data size and compression
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] pg_dump and quoted identifiers
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] pg_dump and quoted identifiers