Re: [PATCH] pg_stat_toast

Am 06.04.22 um 17:49 schrieb Robert Haas:

> I feel like if you want to know whether externalization made a
> difference, you can look at the size of the TOAST table. And by
> selecting directly from that table, you can even see how many chunks
> it contains, and how many are full-sized chunks vs. partial chunks,
> and stuff like that. And for compression, how about looking at
> pg_column_size(col1) vs. pg_column_size(col1||'') or something like
> that? You might get a 1-byte varlena header on the former and a 4-byte
> varlena header on the latter even if there's no compression, but any
> gains beyond 3 bytes have to be due to compression.

I'll probably give that a shot!

It does feel a bit like noting your mileage on fuel receipts though, as
I've done until I got my first decent car; works and will work perfectly
well up to the day, but  certainly is a bit out-of-time (and requires
some basic math skills ;-).

Best,
-- 
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