Date: Fri, 13 Dec 2024 10:03:51 +0000 (UTC)
From: SASIKUMAR Devaraj <sashikumard@yahoo.com>
To: vignesh kumar <vigneshkumar.venugopal@outlook.com>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: <1727122332.1852194.1734084231873@mail.yahoo.com>
In-Reply-To: 
 <MN0PR20MB49129306EE76C40E778EE7A5873F2@MN0PR20MB4912.namprd20.prod.outlook.com>
References: <155477463.1496353.1733983706261.ref@mail.yahoo.com>
 <155477463.1496353.1733983706261@mail.yahoo.com>
 <MN0PR20MB49129306EE76C40E778EE7A5873F2@MN0PR20MB4912.namprd20.prod.outlook.com>
Subject: Re: VacuumDB generating huge WAL filed
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1852193_471542964.1734084231872"
Content-Length: 4326
Archived-At: 
 <https://www.postgresql.org/message-id/1727122332.1852194.1734084231873%40mail.yahoo.com>
Precedence: bulk

------=_Part_1852193_471542964.1734084231872
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

We were able to identify the table generating around 40GB in few mins by va=
ccum process. It is partition table with dead tuple less than 0.5 percent. =
What may be next steps?


Sent from Yahoo Mail for iPhone


On Thursday, December 12, 2024, 8:37 PM, vignesh kumar <vigneshkumar.venugo=
pal@outlook.com> wrote:

Check for the max walsize allocated in postgresql.conf and also check on ch=
eckpoint completion target default is 0.9 this says how frequent the checkp=
oint 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 AndroidFrom: 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=C2=A0Hi All
When we are running vacuumdb for our database of 1.5TB it is generating app=
roximately 60GB of WAL files? Any way we can reduce this WAL file generatio=
n?
RegardsSasi


Sent from Yahoo Mail for iPhone


------=_Part_1852193_471542964.1734084231872
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>
We were able to identify the table generating around 40GB in few mins by vaccum process. It is partition table with dead tuple less than 0.5 percent. What may be next steps?<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><br><p class="yahoo-quoted-begin" style="font-size: 15px; color: rgb(132, 115, 255); padding-top: 15px; margin-top: 0px;">On Thursday, December 12, 2024, 8:37 PM, vignesh kumar &lt;vigneshkumar.venugopal@outlook.com&gt; wrote:</p><blockquote class="iosymail"><div id="yiv9842980609"><div>
<div>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.</div>
<div><br clear="none">
</div>
<div>First do a table level vaccuum and see what's causing it to write more wal files.</div>
<div id="yiv9842980609ms-outlook-mobile-signature">
<div><br clear="none">
</div>
Sent from <a rel="nofollow noopener noreferrer" shape="rect" target="_blank" href="https://aka.ms/AAb9ysg">Outlook for Android</a></div>
<hr style="display:inline-block;width:98%;" tabindex="-1">
<div id="yiv9842980609yqt16873" class="yiv9842980609yqt3241630195"><div dir="ltr" id="yiv9842980609divRplyFwdMsg"><b>From:</b> SASIKUMAR Devaraj &lt;sashikumard@yahoo.com&gt;<br clear="none">
<b>Sent:</b> Thursday, December 12, 2024 11:38:26 AM<br clear="none">
<b>To:</b> Pgsql-admin &lt;pgsql-admin@lists.postgresql.org&gt;<br clear="none">
<b>Subject:</b> VacuumDB generating huge WAL filed
<div>&nbsp;</div>
</div>
<div>Hi All
<div><br clear="none">
</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 clear="none">
</div>
<div>Regards</div>
<div>Sasi<br clear="none">
<br clear="none">
<br clear="none">
<div class="yiv9842980609x_yahoo-signature"><a rel="nofollow noopener noreferrer" shape="rect" target="_blank" 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_" style="font-size:12px;">Sent
 from Yahoo Mail for iPhone</a><br clear="none">
</div>
</div>
</div></div>
</div></div><blockquote></blockquote></blockquote>
</body></html>
------=_Part_1852193_471542964.1734084231872--