| From: | Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> |
|---|---|
| To: | Andrei Zubkov <zubkov(at)moonset(dot)ru> |
| Cc: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Andrei Lepikhov <lepihov(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, 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>, 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-17 16:38:41 |
| Message-ID: | 68939c47-fa0c-4198-853a-92d1390079da@yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi!
On 17.03.2026 18:27, Andrei Zubkov wrote:
> Hi, Alena!
>
> I have some thoughts about your descriptions in the docs (V34). It looks
> clearer now, but in seems to me it still contains some inaccuracy..
>
> 1. Naming: The meaning of 'visible/frozen_pages_cleared' seems to me as
> cleared pages rather then cleared marks... Maybe it should be
> 'visible_page_marks_cleared'?
I agree, this improves clarity. I've renamed it as proposed.
> 2. Mention of a <command>VACUUM</command> in the docs may be understood
> as related to manual VACUUM command only. However, autovacuum is
> accounted as well.. I think we can use just term 'vacuum' here as a
> facility rather than command.
>
Fixed. Clarified that this applies to both manual
<command>VACUUM</command> and autovacuum.
I also added an additional test scenario where one process holds a
transaction open while another process deletes tuples. We expect that
the all-visible and all-frozen flags, previously set by VACUUM, are
cleared only after the deleting transaction commits and the changes
become visible.
-----------
Best regards,
Alena Rybakina
| Attachment | Content-Type | Size |
|---|---|---|
| v35-0001-Track-table-VM-stability.patch | text/plain | 21.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2026-03-17 16:38:45 | Re: Expanding HOT updates for expression and partial indexes |
| Previous Message | Nathan Bossart | 2026-03-17 16:34:04 | Re: Add starelid, attnum to pg_stats and leverage this in pg_dump |