Postgres Pro
Downloads
Home   >   mailing lists

Re: VacuumDB generating huge WAL filed - Mailing list pgsql-admin

From David G. Johnston
Subject Re: VacuumDB generating huge WAL filed
Date
Msg-id CAKFQuway7Ly58D_e8UBaDR4hCw9T-2yvWiJ3+EZNzbvXoRWjMQ@mail.gmail.com
Whole thread Raw
In response to VacuumDB generating huge WAL filed  (SASIKUMAR Devaraj <sashikumard@yahoo.com>)
Responses Re: VacuumDB generating huge WAL filed
List pgsql-admin
Tree view
On Wednesday, December 11, 2024, SASIKUMAR Devaraj <sashikumard@yahoo.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.

pgsql-admin by date:

Previous
From: SASIKUMAR Devaraj
Date:
Subject: VacuumDB generating huge WAL filed
Next
From: Laurenz Albe
Date:
Subject: Re: VacuumDB generating huge WAL filed