| From: | Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> |
|---|---|
| To: | Vlada Pogozhelskaya <pogozhelskaya(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Karina Litskevich <litskevichkarina(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, Andrei Lepikhov <lepihov(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>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
| Subject: | Re: Vacuum statistics |
| Date: | 2026-10-14 11:50:42 |
| Message-ID: | b3219f39-5912-42af-83e0-9ded99e98f7b@yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 13.10.2026 16:02, Alena Rybakina wrote:
> Hi, all!
>
> Rebased version and fixed some bugs that have been found:
>
> * Double-counted deleted index pages: VACUUM counted pages deleted
> by earlier runs. It now counts only newly deleted pages, including
> in parallel mode.
> * Outdated statistics file version: Updated the format version so
> old statistics files aren’t read using the new structure layouts.
> * Missing catalog version bump: Updated |catversion| to prevent
> startup with old system catalogs lacking the new functions and
> columns.
>
>
>
Sorry, I used outdated master version from my fork, now it should be
correct.
| Attachment | Content-Type | Size |
|---|---|---|
| v47-0001-Report-per-index-removed-tuples-in-vacuum-instru.patch | text/plain | 1.4 KB |
| v47-0002-Track-vacuum-times-for-indexes-and-databases-and.patch | text/plain | 37.3 KB |
| v47-0003-Count-wraparound-failsafe-vacuums-in-pg_stat-vie.patch | text/plain | 15.7 KB |
| v47-0004-Count-vacuums-interrupted-by-errors-in-pg_stat_d.patch | text/plain | 15.7 KB |
| v47-0005-Vacuum-report-hook-and-the-ext_vacuum_statistics.patch | text/plain | 65.6 KB |
| v47-0006-ext_vacuum_statistics-page-counters-for-tables-a.patch | text/plain | 22.1 KB |
| v47-0007-ext_vacuum_statistics-WAL-metrics-and-the-per-da.patch | text/plain | 63.0 KB |
| v47-0008-ext_vacuum_statistics-shared-buffer-access-count.patch | text/plain | 29.9 KB |
| v47-0009-Track-table-VM-stability.patch | text/plain | 30.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | Jakub Wartak | 2026-10-14 11:38:17 | Re: log XLogPrefetch stats at end of recovery |