Re: Change prefetch and read strategies to use range in pg_prewarm ... and raise a question about posix_fadvise WILLNEED

From: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
To: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>
Cc: Cédric Villemain <Cedric(dot)Villemain(at)abcsql(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Change prefetch and read strategies to use range in pg_prewarm ... and raise a question about posix_fadvise WILLNEED
Date: 2024-04-07 08:26:34
Message-ID: CAN55FZ0K-9Du-6cc3Y-m8-mCYXbH8Xrjv812ssqEd1wnNr=WQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Andrey,

On Sun, 7 Apr 2024 at 08:29, Andrey M. Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>
>
>
> > On 15 Mar 2024, at 17:12, Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> wrote:
> >
> > I did not have the time to check other things you mentioned but I
> > tested the read performance. The table size is 5.5GB, I did 20 runs in
> > total.
>
> Hi Nazir!
>
> Do you plan to review anything else? Or do you think it worth to look at by someone else? Or is the patch Ready for Committer? If so, please swap CF entry [0] to status accordingly, currently it's "Waiting on Author".

Thanks for reminding me! I think this needs review by someone else
(especially the prefetch part) so I changed it to 'Needs review'.

--
Regards,
Nazir Bilal Yavuz
Microsoft

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Borisov 2024-04-07 08:34:42 Re: Table AM Interface Enhancements
Previous Message Michael Banck 2024-04-07 07:43:39 Re: [PATCH] Exponential backoff for auth_delay