[PATCH] pg_stat_toast v0.3

From: "Gunnar \"Nick\" Bluth" <gunnar(dot)bluth(at)pro-open(dot)de>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: [PATCH] pg_stat_toast v0.3
Date: 2021-12-20 13:31:17
Message-ID: 01de4bbf-1ea5-fa5a-f348-336f5808fd31@pro-open.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Am 12.12.21 um 17:20 schrieb Gunnar "Nick" Bluth:
> Hello -hackers!
> Please have a look at the attached patch, which implements some
> statistics for TOAST.

The attached v0.3 includes
* a proper GUC "track_toast" incl. postgresql.conf.sample line
* gathering timing information
* the system view "pg_stat_toast"
* naming improvements more than welcome!
* columns "storagemethod" and "compressmethod" added as per Hayato
Kuroda's suggestion
* documentation (pointing out the potential impacts as per Andres
Freund's reservations)

Any hints on how to write meaningful tests would be much appreciated!
I.e., will a test

INSERTing some long text to a column raises the view counts and
"compressedsize" is smaller than "originalsize"


Cheers & best regards,
Gunnar "Nick" Bluth

Eimermacherweg 106
D-48159 Münster

Mobil +49 172 8853339
Email: gunnar(dot)bluth(at)pro-open(dot)de
"Ceterum censeo SystemD esse delendam" - Cato

Attachment Content-Type Size
pgstat_toast_v0.3.patch text/x-patch 40.9 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2021-12-20 13:34:11 Re: Multi-Column List Partitioning
Previous Message Amit Langote 2021-12-20 13:17:16 Re: simplifying foreign key/RI checks