Re: SLRUs in the main buffer pool - Page Header definitions

From: "Bagga, Rishu" <bagrishu(at)amazon(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Andres Freund <andres(at)anarazel(dot)de>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "Debnath, Shawn" <sdn(at)amazon(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: SLRUs in the main buffer pool - Page Header definitions
Date: 2023-08-18 08:12:41
Message-ID: 561F9C5A-1903-48E3-86A5-B005D9A66377@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


* Frost, Stephen (sfrowt(at)snowman(dot)net) wrote:

> Haven't really looked over the patches yet but I wanted to push back
> on this a bit- you're suggesting that we'd continue to maintain and
> update slru.c for the benefit of extensions which use it while none of
> the core code uses it? For how long? For my 2c, at least, I'd rather
> we tell extension authors that they need to update their code instead.
> There's reasons why we're moving the SLRUs into the main buffer pool
> and having page headers for them and using the existing page code to
> read/write them and extension authors should be eager to gain those
> advantages too. Not sure how much concern to place on extensions that
> aren't willing to adjust to changes like these.

Hi Stephen,

Thanks for your response. I proposed this version of the patch with the
idea to make the changes gradual, and to minimize disruption of existing
functionality, with the idea of eventually deprecating the SLRUs. If the
community is okay with completely removing the extensible SLRU
mechanism, we don't have any objection to it either.

On another note, I have also attached an updated version of the last
patch-set which is applicable on the latest commits.

Sincerely,

Rishu Bagga, Amazon Web Services (AWS)

Attachment Content-Type Size
0001-slru_to_buf_munro_rebase.patch application/octet-stream 164.4 KB
0002-slru_to_buf_crit_section_fix.patch application/octet-stream 16.6 KB
0003-slru_to_buf_keep_slru_use_nrels.patch application/octet-stream 131.9 KB
0004-slru_to_buf_page_headers_with_upgrade.patch application/octet-stream 47.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhijie Hou (Fujitsu) 2023-08-18 08:16:41 RE: Adding a LogicalRepWorker type field
Previous Message Andy Fan 2023-08-18 07:41:13 Re: Extract numeric filed in JSONB more effectively