[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Get size of variable-length attribute as stored on disk
From:       Christophe Pettus <xof () thebuild ! com>
Date:       2022-12-15 18:26:53
Message-ID: 0803897E-EFBC-4AFC-90E2-98AE974B2FE1 () thebuild ! com
[Download RAW message or body]



> On Dec 15, 2022, at 10:23, Christophe Pettus <xof@thebuild.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!=


[prev in list] [next in list] [prev in thread] [next in thread]