| 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: | Whole Thread | Raw Message | 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 |