el
-Original Message-
From: Adrian Klaver
Sent: 04 July 2024 17:43
To: Shenavai, Manuel ; pgsql-general
Subject: Re: Configure autovacuum
On 7/4/24 08:16, Shenavai, Manuel wrote:
We see that our DB keeps increasing under high load (many updates). We see that
our DB has a size of 200G
andom bytearray of x MB) for x minutes. We update up
to 60MB per second
4) Postgres Version: 14.12-2
5) We are using default autovacuum-settings
Best regards,
Manuel
-Original Message-
From: Adrian Klaver
Sent: 04 July 2024 17:43
To: Shenavai, Manuel ; pgsql-general
Subject: Re: Confi
Message-
From: Adrian Klaver
Sent: 14 June 2024 16:32
To: Shenavai, Manuel ; pgsql-general
Subject: Re: Configure autovacuum
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
-Original Message-
From: Adrian Klaver
Sent: 14 June 2024 16:32
To: Shenavai, Manuel ; pgsql-general
Subject: Re: Configure autovacuum
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
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
On Fri, Jun 14, 2024 at 2:20 AM 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
> settings on my table:
>
> alter table mytable set (autovacuum_vacuum_scale_fa
On Fri, 2024-06-14 at 06:20 +, Shenavai, Manuel wrote:
> 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 settings on my
> table:
> alter table mytable set (autovacuum_vacuum_scale_factor = 0.0);
> alter
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 settings on my table:
alter table mytable set (autovacuum_vacuum_scale_factor = 0.0);
alter table mytable set (autovacuum_vacuum_cost_delay = 0.0
