| From: | Andrei Lepikhov <lepihov(at)gmail(dot)com> |
|---|---|
| To: | Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Jim Nasby <jnasby(at)upgrade(dot)com>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Andrei Zubkov <zubkov(at)moonset(dot)ru>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> |
| Subject: | Re: Vacuum statistics |
| Date: | 2026-03-13 09:31:53 |
| Message-ID: | 1885f257-46cc-4b90-8d90-41833eb62ea9@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 12/3/26 19:10, Alena Rybakina wrote:
> On 12.03.2026 18:28, Andrei Lepikhov wrote:
>
>>
>> In addition, it makes sense to discuss how these parameters are
>> supposed to be used. I see the following use cases:
>>
>> 1. Which tables have the most VM churn? - monitoring
>> rev_all_visible_pages normalised on the table size and its average
>> tuple width might expose the most suspicious tables (in terms of table
>> statistics).
>> 2. DML Skew. Dividing rev_all_visible_pages by the number of tuple
>> updates/deletes, normalised by the average table and tuple sizes,
>> might indicate whether changes are localised within the table.
>> 3. IndexOnlyScan effectiveness. Considering the speed of
>> rev_all_visible_pages change, normalised to the value of the
>> relallvisible statistic, we may detect tables where Index-Only Scan
>> might be inefficiently used.
>>
>>
> I agree with all these points and I think we can add it in the
> documentation.
I've updated the status to 'Ready for Committer'. Here’s what that means:
1. Patch v30-0001-* is ready to be committed. It’s straightforward
enough for this late stage of development. It’s now separate from the
original 'vacuum statistics' idea, which helps keep things simpler.
2. Patches 0002 and 0003 are not part of this commit set. I’m not sure
they should be included in PG19, and we can keep working on them.
--
regards, Andrei Lepikhov,
pgEdge
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jelte Fennema-Nio | 2026-03-13 09:39:39 | Re: Add GoAway protocol message for graceful but fast server shutdown/switchover |
| Previous Message | Bertrand Drouvot | 2026-03-13 09:18:59 | Re: Defend against -ffast-math in meson builds |