Re: Get size of variable-length attribute as stored on disk

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Get size of variable-length attribute as stored on disk
Date: 2022-12-15 18:26:53
Message-ID: 0803897E-EFBC-4AFC-90E2-98AE974B2FE1@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Dec 15, 2022, at 10:23, Christophe Pettus <xof(at)thebuild(dot)com> wrote:
> Is there a way from SQL to get the size of a particular attribute (field in a row) with a variable-length typed as stored on disk (including compression)? The use case is to determine the size distribution for setting TOAST_TUPLE_TARGET and making other decisions about what to store in that field.

Like, for instance, pg_column_size. :-) Never mind!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-12-15 19:51:07 Re: Test if a database has any privilege granted to public
Previous Message Christophe Pettus 2022-12-15 18:23:46 Get size of variable-length attribute as stored on disk