Re: pgsql: Use pre-fetching for ANALYZE

2022-06-06 Thread Stephen Frost
Greetings, * Andres Freund (and...@anarazel.de) wrote: > On 2022-06-02 19:30:16 -0700, Andres Freund wrote: > > On 2021-03-16 18:48:08 +, Stephen Frost wrote: > > > Use pre-fetching for ANALYZE > > > > > > When we have posix_fadvise() available, we can improve the performance > > > of an ANAL

Re: pgsql: Use pre-fetching for ANALYZE

2022-06-02 Thread Andres Freund
Hi, On 2022-06-02 19:30:16 -0700, Andres Freund wrote: > On 2021-03-16 18:48:08 +, Stephen Frost wrote: > > Use pre-fetching for ANALYZE > > > > When we have posix_fadvise() available, we can improve the performance > > of an ANALYZE by quite a bit by using it to inform the kernel of the > >

Re: pgsql: Use pre-fetching for ANALYZE

2022-06-02 Thread Andres Freund
Hi, On 2021-03-16 18:48:08 +, Stephen Frost wrote: > Use pre-fetching for ANALYZE > > When we have posix_fadvise() available, we can improve the performance > of an ANALYZE by quite a bit by using it to inform the kernel of the > blocks that we're going to be asking for. Similar to bitmap in