Postgres Pro
Downloads
Home   >   mailing lists

Re: Prefetch the next tuple's memory during seqscans - Mailing list pgsql-hackers

From David Rowley
Subject Re: Prefetch the next tuple's memory during seqscans
Date
Msg-id CAApHDvqcGsGrm6HQzFFFK7_XX2T3Q+q++u+c0yNncGLsHb8H+w@mail.gmail.com
Whole thread Raw
In response to Re: Prefetch the next tuple's memory during seqscans  (sirisha chamarthi <sirichamarthi22@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, 23 Nov 2022 at 21:26, sirisha chamarthi
<sirichamarthi22@gmail.com> wrote:
> Master
> After vacuum:
> latency average = 393.880 ms
>
> Master + 0001 + 0005
> After vacuum:
> latency average = 369.591 ms

Thank you for running those again.  Those results make more sense.
Would you mind also testing the count(*) query too?

David

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Hash index build performance tweak from sorting
Next
From: Simon Riggs
Date:
Subject: Re: Hash index build performance tweak from sorting