Re: Configure autovacuum

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Shenavai, Manuel" <manuel(dot)shenavai(at)sap(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Configure autovacuum
Date: 2024-06-14 14:32:04
Message-ID: 8d268806-6162-4c31-a516-e3b1c13024b5@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/13/24 23:20, Shenavai, Manuel wrote:
> Hi everyone,
>
> I would like to configure the autovacuum in a way that it runs very
> frequently (i.e. after each update-statement). I tried the following

Why?

What is the problem you are trying to solve?

> settings on my table:
>
> alter table mytable set (autovacuum_vacuum_scale_factor  = 0.0);
>
> alter table mytable set (autovacuum_vacuum_cost_delay  = 0.0);
>
> alter table mytable set (autovacuum_vacuum_cost_limit  = 10000);
>
> alter table mytable set (autovacuum_vacuum_threshold  = 1);
>
> I do a lot of updates on a single tuple and I would expect that the
> autovacuum would start basically after each update (due to
> autovacuum_vacuum_threshold=1). But the autovacuum is not running.
>
> Is it possible to configure postgres to autovacuum very aggressively
> (i.e. after each update-statement)?
>
> Thanks in advance &
>
> Best regards,
>
> Manuel
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2024-06-14 20:08:04 Re: DROP COLLATION vs pg_collation question
Previous Message Ron Johnson 2024-06-14 09:17:36 Re: Configure autovacuum