Re: Missing mention of autovacuum_work_mem

From: "nikolai(dot)berkoff" <nikolai(dot)berkoff(at)pm(dot)me>
To: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Missing mention of autovacuum_work_mem
Date: 2021-09-20 08:07:35
Message-ID: 1kIqf6Q1G-wVkQkeg_BRSpcmy77hNfh9vlLQ3AF1APT-pKHRYT3z1IuDC5K2w83-4Qa016V1SfWJfF1v0Z0qf6141DbLcpIZJY3edlBEkCs=@pm.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

There was no follow up to my message below so I'm raising it again.

I can see in
src/backend/access/heap/vacuumlazy.c
that compute_max_dead_tuples uses autovacuum_work_mem when it is given.

> The "vacuuming indexes" documentation has:
>

> "If a table has any indexes, this will happen at least once per vacuum,
> after the heap has been completely scanned. It may happen multiple times per
> vacuum if maintenance_work_mem is insufficient to store the number of dead
> tuples found."
>

> should be something like
>

(I've changed this slightly and removed maximum as it seems redundant)

"If a table has any indexes, this will happen at least once per vacuum,
after the heap has been completely scanned. It may happen multiple times per
vacuum if the memory is insufficient to store the number of dead
tuples found. The memory is set via the maintenance_work_mem unless
it is an autovacuum then autovacuum_work_mem will be used."

Attachment Content-Type Size
publickey - nikolai.berkoff@pm.me - 0xD189792D.asc application/pgp-keys 1.8 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2021-09-20 13:09:36 Re: Missing mention of autovacuum_work_mem
Previous Message David G. Johnston 2021-09-20 06:35:47 Re: Common case not at all clear