Re: VacuumDB generating huge WAL filed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

Sent from Outlook for Android

From: SASIKUMAR Devaraj <sashikumard@xxxxxxxxx>
Sent: Thursday, December 12, 2024 11:38:26 AM
To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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
Sasi



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux