MIME-Version: 1.0
References: 
 <CA+M9Y+B03KvHX2qUfvepv6_u72V7b-_zR_=SnMueBrG5xQ34Jw@mail.gmail.com>
In-Reply-To: 
 <CA+M9Y+B03KvHX2qUfvepv6_u72V7b-_zR_=SnMueBrG5xQ34Jw@mail.gmail.com>
From: Muhammad Imtiaz <imtiazpg712@gmail.com>
Date: Tue, 13 Aug 2024 13:15:44 +0500
Message-ID: 
 <CACW1Ly0wG4MZ+OgAWBDZwPXmNW_--+iWqp3mmru40iu=C8v3aw@mail.gmail.com>
Subject: Re: Pg_repack
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e7bcc4061f8c376b"
Archived-At: 
 <https://www.postgresql.org/message-id/CACW1Ly0wG4MZ%2BOgAWBDZwPXmNW_--%2BiWqp3mmru40iu%3DC8v3aw%40mail.gmail.com>
Precedence: bulk

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

Hi,

Pg_repack doesn=E2=80=99t use unlogged tables, but you can minimize WAL fil=
e size
by enabling wal_compression in postgresql.conf. Additionally, you can
fine-tune wal_buffers, checkpoint_timeout, and checkpoint_completion_target
to better manage WAL file size.

Regards,
Muhammad Imtiaz

On Mon, Aug 12, 2024 at 4:48=E2=80=AFPM Sathish Reddy <
sathishreddy.postgresql@gmail.com> wrote:

> Hi
>   We have configure pg_repack on database.when we ran pg_repak it is usin=
g
> temporary table on repack once repack done it is going to swap temporary
> table to original .on these case it is genarate huse wal files and it
> getting size increase be end .
>
>     We need help on these instead of using temporary table can we use
> unlog table on reduce these wal case.
>
>
> Thanks
> Sathishreddy
>

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

<div dir=3D"ltr">Hi,<br><br>Pg_repack doesn=E2=80=99t use unlogged tables, =
but you can minimize WAL file size by enabling wal_compression in postgresq=
l.conf. Additionally, you can fine-tune wal_buffers, checkpoint_timeout, an=
d checkpoint_completion_target to better manage WAL file size.<br><br>Regar=
ds,<br>Muhammad Imtiaz</div><br><div class=3D"gmail_quote"><div dir=3D"ltr"=
 class=3D"gmail_attr">On Mon, Aug 12, 2024 at 4:48=E2=80=AFPM Sathish Reddy=
 &lt;<a href=3D"mailto:sathishreddy.postgresql@gmail.com">sathishreddy.post=
gresql@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex"><div dir=3D"auto">Hi=C2=A0<div dir=3D"auto">=C2=A0 We have =
configure pg_repack on database.when we ran pg_repak it is using temporary =
table on repack once repack done it is going to swap temporary table to ori=
ginal .on these case it is genarate huse wal files and it getting size incr=
ease be end .=C2=A0</div><div dir=3D"auto">=C2=A0 =C2=A0</div><div dir=3D"a=
uto">=C2=A0 =C2=A0 We need help on these instead of using temporary table c=
an we use unlog table on reduce these wal case.</div><div dir=3D"auto"><br>=
</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks=C2=A0</div><div =
dir=3D"auto">Sathishreddy=C2=A0</div></div>
</blockquote></div>

--000000000000e7bcc4061f8c376b--