Re: VacuumDB generating huge WAL filed

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: VacuumDB generating huge WAL filed
Date: 2024-12-12 06:25:52
Message-ID: CAKFQuway7Ly58D_e8UBaDR4hCw9T-2yvWiJ3+EZNzbvXoRWjMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wednesday, December 11, 2024, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
wrote:

>
> When we are running vacuumdb for our database of 1.5TB it is generating
> approximately 60GB of WAL files? Any way we can reduce this WAL file
> generation?
>
>
Set a much more aggressive autovacuum so you don’t accumulate as much dead
tuples between runs?

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-12-12 06:35:47 Re: VacuumDB generating huge WAL filed
Previous Message SASIKUMAR Devaraj 2024-12-12 06:08:26 VacuumDB generating huge WAL filed