| From: | Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> |
|---|---|
| To: | Alena Rybakina <a(dot)rybakina(at)postgrespro(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-02-28 22:20:00 |
| Message-ID: | 277ce149-4333-463d-bad6-ccd785606c7f@yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 21.12.2025 04:36, Alena Rybakina wrote:
>
> Hi,
> I’ve added some changes to one of the approaches and also did
> additional cleanup and stabilization work on the vacuum statistics
> tests. Specifically:
>
> * I moved the vacuum statistics tests into the tests tab and made
> them more stable. For slower machines, vacuum is now triggered
> inside the statistics wait function. Previously, some backends
> didn’t have enough time to release the lock, which could lead to
> differences because the vacuum hadn’t fully completed yet.
> * I also ran the backend tests and fixed a couple of minor issues
> along the way.
> * I ran pgindent to clean up and normalize the formatting.
>
I have rebased the patch.
I combined all the patches for implementing statistics on tables,
indexes, and databases into one, creating a separate slot for them to
collect and save statistics.
> At the moment, only the second test still looks odd, and I haven’t
> fully figured out why yet. It seems like aggressive vacuum can no
> longer be triggered the same way as before with the current gucs, but
> I’m still investigating this.
>
I fixed this problem - it works well now.
Best regards,
Alena Rybakina
| Attachment | Content-Type | Size |
|---|---|---|
| v27-0001-Introduce-new-statistics-tracking-the-number-of-time.patch | text/plain | 9.3 KB |
| v27-0002-Add-machinery-for-grabbing-an-extended-vacuum-statis.patch | text/plain | 113.4 KB |
| v27-0003-Add-documentation-about-the-system-views-that-are-us.patch | text/plain | 25.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lukas Fittl | 2026-02-28 23:46:39 | pg_stat_statements: Add gc_count and query_file_size to pgss_info |
| Previous Message | Andres Freund | 2026-02-28 22:08:04 | Re: index prefetching |