MIME-Version: 1.0
References: <CA+ONtZ4q9OkEHx0pCf87Z876=_vM7=+Ko18HF8+WHrENQ8mxLg@mail.gmail.com>
 <CANzqJaB4Qz2iqvaprSHH18=A3neAMBugJ4OLoZr2UZ3rQiUF2A@mail.gmail.com> <CA+ONtZ6q4+wcNH9dPZm2tugLaU98xrf7iU8UA6JC2NVYtW_JRw@mail.gmail.com>
In-Reply-To: <CA+ONtZ6q4+wcNH9dPZm2tugLaU98xrf7iU8UA6JC2NVYtW_JRw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 7 Mar 2025 15:07:12 -0500
Message-ID: <CANzqJaAkTrMobswbupC=6XYaex47iwC6rz4WpaK=HSbZZMpcxQ@mail.gmail.com>
Subject: Re: No. Of wal files generated
To: Atul Kumar <akumar14871@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c88400062fc62bef"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAkTrMobswbupC%3D6XYaex47iwC6rz4WpaK%3DHSbZZMpcxQ%40mail.gmail.com>
Precedence: bulk

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

inotifywait can log every file creation and deletion in a directory.

Honestly, though, I'd strongly think about using PgBackRest instead of
something you wrote yourself.

On Fri, Mar 7, 2025 at 2:47=E2=80=AFPM Atul Kumar <akumar14871@gmail.com> w=
rote:

> I want to check and compare the speed  wal file generation process and
> archival process.
>
> So I want to check how many wal file got created in x minutes and how man=
y
> .ready files got created in those x minutes.
>
>
>
> Regards,
> Atul
>
> On Fri, 7 Mar 2025, 22:45 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
>
>> On Fri, Mar 7, 2025 at 10:59=E2=80=AFAM Atul Kumar <akumar14871@gmail.co=
m> wrote:
>>
>>> Hi,
>>>
>>> Please could you help me by sharing any redhat linux command through
>>> which I can count the no. of wal files and no. of ".ready" files genera=
ted
>>> in last 10 minutes.
>>>
>>
>> What problem are you trying to solve?
>>
>> --
>> Death to <Redacted>, and butter sauce.
>> Don't boil me, I'm still alive.
>> <Redacted> lobster!
>>
>

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr">inotifywait can log every file creation and deletion in a =
directory.<div><br></div><div>Honestly, though, I&#39;d strongly think abou=
t using PgBackRest instead of something you wrote yourself.</div></div><br>=
<div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"=
gmail_attr">On Fri, Mar 7, 2025 at 2:47=E2=80=AFPM Atul Kumar &lt;<a href=
=3D"mailto:akumar14871@gmail.com">akumar14871@gmail.com</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">I =
want to check and compare the speed=C2=A0 wal file generation process and a=
rchival process.<div dir=3D"auto"><br></div><div dir=3D"auto">So I want to =
check how many wal file got created in x minutes and how many .ready files =
got created in those x minutes.=C2=A0</div><div dir=3D"auto"><br></div><div=
 dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto">Regar=
ds,</div><div dir=3D"auto">Atul</div></div><br><div class=3D"gmail_quote"><=
div dir=3D"ltr" class=3D"gmail_attr">On Fri, 7 Mar 2025, 22:45 Ron Johnson,=
 &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"_blank">ronljohns=
onjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Fri, Mar 7, 2025 at 10:5=
9=E2=80=AFAM Atul Kumar &lt;<a href=3D"mailto:akumar14871@gmail.com" rel=3D=
"noreferrer" target=3D"_blank">akumar14871@gmail.com</a>&gt; wrote:</div><d=
iv class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
<div dir=3D"auto">Hi,<div dir=3D"auto"><br></div><div dir=3D"auto">Please c=
ould you help me by sharing any redhat linux command through which I can co=
unt the no. of wal files and no. of &quot;.ready&quot; files generated in l=
ast 10 minutes.=C2=A0</div></div></blockquote><div><br></div><div>What prob=
lem are you trying to solve?</div></div><div><br></div><span class=3D"gmail=
_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"=
><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;=
t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div=
></div></div></div></div></div>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div>

--000000000000c88400062fc62bef--