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.bluth@pro-open.de
__________________________________________________________________________
"Ceterum censeo SystemD esse delendam" - Cato