Horton

Thread

Commits

  1. Search for SLRU page only in its own bank

  2. Improve performance of subsystems on top of SLRU

  1. BUG #18582: fixed range of search for empty slot in SLRU

    The Post Office <noreply@postgresql.org> — 2024-08-13T12:29:57Z

    The following bug has been logged on the website:

Bug reference:      18582
Logged by:          Sergey Sargsyan
Email address:      sergey.sargsyan.2001@gmail.com
PostgreSQL version: 17beta3
Operating system:   Linux
Description:        

pageno should be searched only inside its own bank, because it may never
appear in other banks.

https://github.com/postgres/postgres/pull/174

  2. Re: BUG #18582: fixed range of search for empty slot in SLRU

    Alvaro Herrera <alvherre@alvh.no-ip.org> — 2024-08-13T18:32:01Z

    On 2024-Aug-13, PG Bug reporting form wrote:

> pageno should be searched only inside its own bank, because it may never
> appear in other banks.
> 
> https://github.com/postgres/postgres/pull/174

For the archives, the patch proposed in the pull request is attached
here.

I agree with this patch.  This is just an innocuous oversight in commit
53c2a97a9266.  Dilip?

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"El sentido de las cosas no viene de las cosas, sino de
las inteligencias que las aplican a sus problemas diarios
en busca del progreso." (Ernesto Hernández-Novich)

  3. Re: BUG #18582: fixed range of search for empty slot in SLRU

    Alvaro Herrera <alvherre@alvh.no-ip.org> — 2024-08-19T01:20:06Z

    On 2024-Aug-13, Alvaro Herrera wrote:

> On 2024-Aug-13, PG Bug reporting form wrote:
> 
> > pageno should be searched only inside its own bank, because it may never
> > appear in other banks.

Thanks for reporting this.  I have pushed it now.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
(Ijon Tichy en Viajes, Stanislaw Lem)

  4. Re: BUG #18582: fixed range of search for empty slot in SLRU

    Sergey Sargsyan <sergey.sargsyan.2001@gmail.com> — 2024-08-19T09:40:18Z

    Glad to be of help.


пн, 19 авг. 2024 г. в 04:20, Alvaro Herrera <alvherre@alvh.no-ip.org>:

> On 2024-Aug-13, Alvaro Herrera wrote:
>
> > On 2024-Aug-13, PG Bug reporting form wrote:
> >
> > > pageno should be searched only inside its own bank, because it may
> never
> > > appear in other banks.
>
> Thanks for reporting this.  I have pushed it now.
>
> --
> Álvaro Herrera         PostgreSQL Developer  —
> https://www.EnterpriseDB.com/
> "El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
> (Ijon Tichy en Viajes, Stanislaw Lem)
>


-- 
Sargsyan Serezha           Platform V Pangolin SE —
platformv.sbertech.ru/products/rabota-s-dannymi/pangolin