| From: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
|---|---|
| To: | Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Jim Nasby <jnasby(at)upgrade(dot)com>, Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(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>, a(dot)lepikhov(at)postgrespro(dot)ru, Sami Imseih <samimseih(at)gmail(dot)com> |
| Subject: | Re: Vacuum statistics |
| Date: | 2025-02-02 20:43:19 |
| Message-ID: | CAPpHfduoJEuoixPTTg2tjhnXqrdobuMaQGxriqxJ9TjN1uxOuA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jan 13, 2025 at 3:26 PM Alena Rybakina
<a(dot)rybakina(at)postgrespro(dot)ru> wrote:
> I noticed that the cfbot is bad, the reason seems to be related to the lack of a parameter in src/backend/utils/misc/postgresql.conf.sample. I added it, it should help.
The patch doesn't apply cleanly. Please rebase.
I see you introduced new GUC variable pgstat_track_vacuum_statistics,
which should address the increased size of statistics. However, I
don't see how it could affect the size of PgStat_StatTabEntry struct.
It seems that when pgstat_track_vacuum_statistics == 0, extended
vacuum statistics is not collected but the size of hash table entries
is the same. Also, should pgstat_track_vacuum_statistics also affect
per database statistics?
The name of 0001 is "... on heap relations". Should we say "on table
relations", because new machinery should work with alternative table
AMs as well.
There are deletions of empty lines in
src/include/utils/pgstat_internal.h and src/include/pgstat.h. Please,
remote them as it's not purpose of this patchset.
------
Regards,
Alexander Korotkov
Supabase
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-02-02 21:26:38 | Re: [PATCH] Fix incorrect range in pg_regress comment |
| Previous Message | Mahendra Singh Thalor | 2025-02-02 20:19:00 | Re: Non-text mode for pg_dumpall |