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.96) (envelope-from ) id 1w6LuG-004DJc-0Q for pgsql-hackers@arkaria.postgresql.org; Sat, 28 Mar 2026 05:08:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6LuE-00DSjz-25 for pgsql-hackers@arkaria.postgresql.org; Sat, 28 Mar 2026 05:08:19 +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.96) (envelope-from ) id 1w6LuE-00DSjq-1D for pgsql-hackers@lists.postgresql.org; Sat, 28 Mar 2026 05:08:18 +0000 Received: from mail-ua1-x934.google.com ([2607:f8b0:4864:20::934]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6LuD-00000001RXu-0UYm for pgsql-hackers@postgresql.org; Sat, 28 Mar 2026 05:08:17 +0000 Received: by mail-ua1-x934.google.com with SMTP id a1e0cc1a2514c-94ab69af6c8so2501893241.0 for ; Fri, 27 Mar 2026 22:08:17 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774674496; cv=none; d=google.com; s=arc-20240605; b=KsVbLQLDRYFncNfMAjpa9I4grlYTHh8/Fm8q8tlotUG3TTvTbY0AXIJ1i23ZvsC6AF 0sOebjW7uzMj4jN7Ol0UHvy9kPUbgVeoBMe4hOxwoLDAjljJLRsFlH+g51HpBStOgJXH M9AYBUgt0Rt4sEnqgTbA9ZGO6lpefR0ass98vW22RuzH5bHWbMJGJLoJ2M4hXWpHHFhu B1JpyFUdIrjk0Me8GY2nIht6TA7AGHw0W3mVJ0/4AuVxZ5QBfbX/z1FN6oQ6EuJGXYGE DhrxuebtEa66/vxSjmkvbZCUh5t/MEnrT12J2zeg1Zz8kauhqC/yVtPtg3xx86G6m5c0 IumQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=QywC7LMTpLht7Vw9i0j2dXS4kGuLRBtwyu0UNSkMdeI=; fh=owbTD1yoa+8OyeOBq4vofuNJo58uQM4Uuw4/3LCliwU=; b=k+UzqZWET7P1prXG0RjlmnYMwH5ws/psQVhYBFAbcRtqksP0luR3Xd5YGl0JsWt7Lr UMYSh/rIKPxnr6zxl8R96HODg1xZ3qPjCmsJ9h9vnZYcL4l2BlWTKan3icS3booJ9bNU 8JzMZXJOFtfVtKjnYDmvnXIJqMAwUGD0PCrlzfS+ZpMi9Agz0gpmSHWnksLsgcdHpZRK McPIDNt0Iwm+ukw462aX05iWXS5Mcns4LWzo5qzYa0oP39LLFGe9NrSsVKNn2oxEFH2M F0SJfgoMzPOl4i7h+7nXtLWN/HNTOiKGCn3wZKYqQT8i1uVIdpmQtiPQcBDOpAdPTvB7 Mbzg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774674496; x=1775279296; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=QywC7LMTpLht7Vw9i0j2dXS4kGuLRBtwyu0UNSkMdeI=; b=ZE8deLrRvCJlQ5J2MtPemHwa0fkrkV/SvlDYY4XoiG87+ZZW9fwNwvjqzsv4r6yjwt Flo1SExB9C8rlDx+fnLPtMZ93w2nz0S1U7U2crkcMhSlCNYT5mPLwiAyQUSoWd2Ab3H8 PYwWLytL5FFfDqgdk3F1jauK1tYnEys38H+Y7ppVJJ9VWzbAuY7QnLSi/o3wrcUC4HuE 57LgsK9Az/gFyFiTwU5WAu7TG7q7wCzIhvwfGtOj+QtEtJc03cAnKHDN9Pte6+ISorFp 5ZZjhanW4J0ypSVrcS3UJg7zMYhWub0H6y1kHbsO2rMPjUhUjd6skPTpKUNHQPLC5d/0 o2Yw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774674496; x=1775279296; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=QywC7LMTpLht7Vw9i0j2dXS4kGuLRBtwyu0UNSkMdeI=; b=m87xPgXe+gniQyKfXKmkA52tSZOQ5m10e9V4lIV2UETZUndRG1vur0SYatTENMIUwX T0SqOxWQV9reNaMun7nm6tBKTBLji/VWZ+Bmdrqd6UvlFEdCBZ0vgkAqVd7s7h1GFfHe MYZeNAkyiz/c3ys2MHF5snLrDbeA+UagnU51FTFIErCN9K8qX27dBXlPL4y5ASm/SRRX GBaxui6xodkMPxyrjx00XWJh5V0khxlD75MuaaU797dau7zsUNjOBf3zNFtzEc5Ac6rc m8S5+pzT1Gkek5s5irusBsJshlVjeNdJ8urc+93NJytuImk+QPe6wpn/jSqxnhzzyVct lEBA== X-Forwarded-Encrypted: i=1; AJvYcCXgPvcGb6o+k4SlnTuB7UMtpxxH1uwQKoso7a7tBMLwV473UCGOoa4ThEpi22yTF434ComES6ivaLJy3BB/@postgresql.org X-Gm-Message-State: AOJu0Yw9114LvNPP3nxFZtc5cFuFkD96a6tz0NV/+o0XYd3oOr9mAGkC mT/cNND1U4dG/NNMYSdJGC7vmlyChGsEC9sz7326SBMw+Q04H7PdS6O0m+qNGuZRsG/cNQvxOKs XwWFupIF7Pw3RnMLCQs6yj1JdxduaewA= X-Gm-Gg: ATEYQzyMLBIJD8A4uluJFimN5w2/m4JCm49dBsvMKlz9RvDAXAVyrxnI6VK99ZdbpTd 7tE54CBmhS3GyRja1iaTWhabqfdrV0x2r0/y2KkOrTk4AhCHOQYXuJ5AGRbFAdHWJ8wsQW5A9+q LXUEvcJ9yQ5eD1kQZJrwM7XWXlXrtEu4yey/BqXzBvfGgdzj4PM47GZdgLfLkP0TXSBx+ZbAQJX BBB/wxdTbIgqyrrwB4oDp3ndaxg/qZpko/Mf0xaQHIBgrWnNn+o9AE9vDc+Vz9Y0HBZV9uvI6Y7 DJ1BTscwb7OQuFr23bVZjLEVkTzUgDrY3IkR/w== X-Received: by 2002:a05:6102:418f:b0:5f8:e41e:e5cc with SMTP id ada2fe7eead31-604fc053b86mr1543519137.9.1774674496376; Fri, 27 Mar 2026 22:08:16 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: SATYANARAYANA NARLAPURAM Date: Fri, 27 Mar 2026 22:08:04 -0700 X-Gm-Features: AQROBzAmKuRnf4q5KQC9Jac-xffa1RJ-izEctzpXu_hF3xdZRs5dFixfVyuEnjI Message-ID: Subject: Re: log XLogPrefetch stats at end of recovery To: Bharath Rupireddy Cc: Lakshmi N , Jakub Wartak , Thomas Munro , pgsql-hackers@postgresql.org Content-Type: multipart/alternative; boundary="000000000000f2d14d064e0e9aa2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f2d14d064e0e9aa2 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Mar 26, 2026 at 5:10=E2=80=AFPM Bharath Rupireddy < bharath.rupireddyforpostgres@gmail.com> wrote: > Hi, > > On Thu, Mar 26, 2026 at 1:06=E2=80=AFAM Lakshmi N wrote: > > > > Address this in the attached patch. Please let me know if this looks > good. > > 2026-03-26 00:51:19.797 PDT [91881] LOG: redo prefetch stats: > prefetched 418376 blocks, skipped (362419 in the buffer pool, 418479 > zero-initialized, 0 non-existent, 9 full page image, 39183318 recently > prefetched) > > Thanks for sending the latest patch. It looks good to me with a > nit:s/362419 in the buffer pool/362419 already in buffer pool. I will > leave it to others' choice LGTM too, I will leave it to the committer's choice. Thanks, Satya --000000000000f2d14d064e0e9aa2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Thu, Mar 26,= 2026 at 5:10=E2=80=AFPM Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>= ; wrote:
Hi,

On Thu, Mar 26, 2026 at 1:06=E2=80=AFAM Lakshmi N <lakshmin.jhs@gmail.com> wrote= :
>
> Address this in the attached patch. Please let me know if this looks g= ood.
> 2026-03-26 00:51:19.797 PDT [91881] LOG:=C2=A0 redo prefetch stats: pr= efetched 418376 blocks, skipped (362419 in the buffer pool, 418479 zero-ini= tialized, 0 non-existent, 9 full page image, 39183318 recently prefetched)<= br>
Thanks for sending the latest patch. It looks good to me with a
nit:s/362419 in the buffer pool/362419 already in buffer pool. I will
leave it to others' choice

LGTM too, I = will leave=C2=A0it to the=C2=A0committer's choice.

=
Thanks,
Satya


--000000000000f2d14d064e0e9aa2--