Date: Thu, 12 Dec 2024 06:08:26 +0000 (UTC)
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <155477463.1496353.1733983706261@mail.yahoo.com>
Subject: VacuumDB generating huge WAL filed
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1496352_1016766610.1733983706260"
References: <155477463.1496353.1733983706261.ref@mail.yahoo.com>
Content-Length: 1390
Archived-At: 
 <https://www.postgresql.org/message-id/155477463.1496353.1733983706261%40mail.yahoo.com>
Precedence: bulk

------=_Part_1496352_1016766610.1733983706260
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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?
RegardsSasi


Sent from Yahoo Mail for iPhone

------=_Part_1496352_1016766610.1733983706260
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><head><!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--></head><body>
Hi All<div><br></div><div>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?</div><div><br></div><div>Regards</div><div>Sasi<br><br><br><div class="yahoo-signature"><a style="font-size:12px" href="https://mail.onelink.me/107872968?pid=nativeplacement&amp;c=Global_Acquisition_YMktg_315_Internal_EmailSignature&amp;af_sub1=Acquisition&amp;af_sub2=Global_YMktg&amp;af_sub3=&amp;af_sub4=100000604&amp;af_sub5=EmailSignature__Static_">Sent from Yahoo Mail for iPhone</a><br></div></div>
</body></html>
------=_Part_1496352_1016766610.1733983706260--