| From: | Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru> |
|---|---|
| To: | PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, Andrei Zubkov <a(dot)zubkov(at)postgrespro(dot)ru> |
| Subject: | Re: Vacuum statistics |
| Date: | 2024-05-30 18:26:38 |
| Message-ID: | 70e1cca9-ff89-4e76-a611-d38bcc0e14ad@yandex.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 30.05.2024 10:33, Alena Rybakina wrote:
>
> I suggest gathering information about vacuum resource consumption for
> processing indexes and tables and storing it in the table and index
> relationships (for example, PgStat_StatTabEntry structure like it has
> realized for usual statistics). It will allow us to determine how well
> the vacuum is configured and evaluate the effect of overhead on the
> system at the strategic level, the vacuum has gathered this
> information already, but this valuable information doesn't store it.
>
My colleagues and I have prepared a patch that can help to solve this
problem.
We are open to feedback.
--
Regards,
Alena Rybakina
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Machinery-for-grabbing-an-extended-vacuum-statistics.patch | text/x-patch | 85.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Zubkov | 2024-05-30 19:19:26 | Re: Vacuum statistics |
| Previous Message | David Christensen | 2024-05-30 17:59:06 | Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs) |