MIME-Version: 1.0
In-Reply-To: <155477463.1496353.1733983706261@mail.yahoo.com>
References: <155477463.1496353.1733983706261.ref@mail.yahoo.com>
 <155477463.1496353.1733983706261@mail.yahoo.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 11 Dec 2024 23:25:52 -0700
Message-ID: 
 <CAKFQuway7Ly58D_e8UBaDR4hCw9T-2yvWiJ3+EZNzbvXoRWjMQ@mail.gmail.com>
Subject: Re: VacuumDB generating huge WAL filed
To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003ea8fa06290cc995"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuway7Ly58D_e8UBaDR4hCw9T-2yvWiJ3%2BEZNzbvXoRWjMQ%40mail.gmail.com>
Precedence: bulk

--0000000000003ea8fa06290cc995
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99t accumulate as mu=
ch dead
tuples between runs?

David J.

--0000000000003ea8fa06290cc995
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, December 11, 2024, SASIKUMAR Devaraj &lt;<a href=3D"mailto:sa=
shikumard@yahoo.com">sashikumard@yahoo.com</a>&gt; wrote:<br><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;p=
adding-left:1ex"><br><div>When we are running vacuumdb for our database of =
1.5TB it is generating approximately 60GB of WAL files? Any way we can redu=
ce this WAL file generation?</div><div><div><br></div></div></blockquote><d=
iv><br></div><div>Set a much more aggressive autovacuum so you don=E2=80=99=
t accumulate as much dead tuples between runs?</div><div><br></div><div>Dav=
id J.</div>

--0000000000003ea8fa06290cc995--