Postgres Pro
Downloads
Home   >   mailing lists

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

From vignesh kumar
Subject Re: VacuumDB generating huge WAL filed
Date
Msg-id MN0PR20MB49129306EE76C40E778EE7A5873F2@MN0PR20MB4912.namprd20.prod.outlook.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
Check for the max walsize allocated in postgresql.conf and also check on checkpoint completion target default is 0.9 this says how frequent the checkpoint can be applied that adds to wal lan generation.

First do a table level vaccuum and see what's causing it to write more wal files.
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Sent: Thursday, December 12, 2024 11:38:26 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: VacuumDB generating huge WAL filed
 
Hi All

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?

Regards

pgsql-admin by date:

Previous
From: "Dischner, Anton"
Date:
Subject: AW: Psql not working
Next
From: SASIKUMAR Devaraj
Date:
Subject: Re: VacuumDB generating huge WAL filed