| From: | Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> |
|---|---|
| To: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| 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-04 15:49:43 |
| Message-ID: | 9f8f2625-7d3a-4eb9-9d91-ceced54ad39c@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 04.02.2025 18:22, Alena Rybakina wrote:
>
>> Also, should pgstat_track_vacuum_statistics also affect
>> per database statistics?
>
> According to my original idea, I thought that we could collect
> extended statistics on relationships depending on whether the hook is
> enabled, and always on databases. This will help us to constantly
> collect statistics on the vacuum and notice when something is wrong
> and at the same time not very expensive: there are much fewer
> databases compared to the same relationships and there are much fewer
> statistics there. You can introduce an additional hook that disables
> all collection of vacuum statistics. This patch can be seen here for
> the 17th version of the patch [0], I have not yet started adding it,
> since we did not come to an agreement.
I added this version as
"v19-0003.2-extended-vacuum-statistics.patch.no-cbot"
--
Regards,
Alena Rybakina
Postgres Professional
| Attachment | Content-Type | Size |
|---|---|---|
| v19-0003.2-extended-vacuum-statistics.patch.no-cfbot | text/plain | 37.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2025-02-04 15:51:19 | Re: Restrict publishing of partitioned table with a foreign table as partition |
| Previous Message | Alena Rybakina | 2025-02-04 15:22:52 | Re: Vacuum statistics |