Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tqiRh-009ESy-U3 for pgsql-general@arkaria.postgresql.org; Sat, 08 Mar 2025 00:53:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tqiRg-003o47-Av for pgsql-general@arkaria.postgresql.org; Sat, 08 Mar 2025 00:53:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tqiRf-003o1O-Lq for pgsql-general@lists.postgresql.org; Sat, 08 Mar 2025 00:53:39 +0000 Received: from mail-ua1-x92f.google.com ([2607:f8b0:4864:20::92f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tqiRd-001acb-2W for pgsql-general@lists.postgresql.org; Sat, 08 Mar 2025 00:53:38 +0000 Received: by mail-ua1-x92f.google.com with SMTP id a1e0cc1a2514c-86718c2c3b9so935002241.2 for ; Fri, 07 Mar 2025 16:53:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741395217; x=1742000017; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=V8HyhRC0puD2MsEzKLC1CF0Ot1owPas+f5tSA5YM+ZE=; b=MzNmQp07nHYPXJMPU/I5He314L32rCoI4v2C/XQO/cIuBFxLBIbdn1KUpAxavb/+2q 14hajMZHUZInGJJKRIx+qOzIhENRpi2VmQr43qoqI4AMoNWaeZxTPJje7YSkUqTjA5cE UtHY1VVzxE3PIZtw+QDqC4ueJzeOCQ6eV1Hu+1CcRr4l668KRNxHx5vN+D8G8cZRLWxN 2z908UHAtHkNZ3WmmBZqcbVOkpBcZQbNmP9lHM9aAidxvo37APulEusCvk/NLJ1/DXLL TZ+Z0Tc39FpbI7kzXc0R1wSNPvCZKzir/qbWnowe+L9niv1ivQnEiOvnR1BLbfZMNVUU QHgA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741395217; x=1742000017; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=V8HyhRC0puD2MsEzKLC1CF0Ot1owPas+f5tSA5YM+ZE=; b=gdyCIUNFjxGkHW4O8Wsqm4y3VyYNTG7AC1IxP+V++vy4+Pr4iZXGlARA8xDkjPPSzK Fx5po+UsoNkDlK+hXJstylS9Fm5uRYj8ZiwiuX92XkxwwSYjayOktXFV679PC39tEDVt FmKF7BCgUiuLnEqO0HJkbfUxbDuQJ8BR2mDtHDbXXc5W/j2EhvZjXvsfi8MBtlExwDkt SnOaBSTNmsNCLFup6o8G+tNzCS/YROPTqIVscCMUKpl0vwgA3uczAe8aovUXsqEk+7TO 4M75lqOyF3d80xvrfriHzrZWVfUqabZS4tks9i/frnvoJOkQ7Ylzp3RRZELhAob5IQhY aKEw== X-Gm-Message-State: AOJu0YxbnQObdbmYG9FMuZ/8QpZRu7nC1mN6xF5CiiOWOhfqZZH9O4d0 MZ4PHYMWh0UP6HQ45qdqurrssHZPwXoSVtT+JT71RQAlhDnyTevJHP+QcTLzBUAovH3FJxgLyeS beUenhhnBAbwJBJ0TpL/1g6sNix7lgA== X-Gm-Gg: ASbGncvi1PJ8hTRObgsGArG7QF0mvm4rGJeHAE6cKAS1/D38no2tku4BuJGYjGmstYK hGi9iXCfn0m8FhQrXqPzj0O7ntlhnDIob0Ob8ovW5e7wdRt0YBQh3t8c04u2mxmvu+eWFyUfGPL NKBP4Hr/QFomWL5zdcmfLzX5fXSMJN5PkLsNWhU/2/XzRdBmcCkQ5EBrRMv5Y= X-Google-Smtp-Source: AGHT+IEyqY0WPnDU80A7gej8l+AXUoHg2LT7yEbQ0o1QKYAiroMgZsVbCYOBwuRAqB5yq55FtMUWSC/CEGA2fRHjuB8= X-Received: by 2002:a05:6102:a54:b0:4c1:b001:b53 with SMTP id ada2fe7eead31-4c30a65e00bmr3704945137.18.1741395216658; Fri, 07 Mar 2025 16:53:36 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Atul Kumar Date: Sat, 8 Mar 2025 06:23:25 +0530 X-Gm-Features: AQ5f1JrU5xZLQZvQ6gWY7QP3hTdbv2IUYNCDE3ffimfQlJM27cj7ihUAXX1BAK8 Message-ID: Subject: Re: No. Of wal files generated To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000004d7cc5062fca2b20" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004d7cc5062fca2b20 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Please can you elaborate more about the meaning of inotifywait. And how pgbackrest will solve the issue ? Regards. On Sat, 8 Mar 2025, 01:37 Ron Johnson, wrote: > 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 = wrote: > >> 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 >> many .ready files got created in those x minutes. >> >> >> >> Regards, >> Atul >> >> On Fri, 7 Mar 2025, 22:45 Ron Johnson, wrote: >> >>> On Fri, Mar 7, 2025 at 10:59=E2=80=AFAM Atul Kumar >>> 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 gener= ated >>>> in last 10 minutes. >>>> >>> >>> What problem are you trying to solve? >>> >>> -- >>> Death to , and butter sauce. >>> Don't boil me, I'm still alive. >>> lobster! >>> >> > > -- > Death to , and butter sauce. > Don't boil me, I'm still alive. > lobster! > --0000000000004d7cc5062fca2b20 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Please can you elaborate more about the meaning of i= notifywait.

And how pgba= ckrest will solve the issue ?


Regards.=C2=A0


On Sat, 8 Mar 202= 5, 01:37 Ron Johnson, <ronljo= hnsonjr@gmail.com> wrote:
inotifywait can log every file creation and deletion in a di= rectory.

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> = wrote:
I want to check and compare the speed=C2=A0 wal file generation p= rocess and archival process.

S= o 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


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 <ak= umar14871@gmail.com> wrote:
Hi,

Please could you help me by sharing any r= edhat linux command through which I can count the no. of wal files and no. = of ".ready" files generated in last 10 minutes.=C2=A0
=

What problem are you trying to solve?

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


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--0000000000004d7cc5062fca2b20--