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 |
Thread: | |
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"
suffice?!?
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 |
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 |