Re: Speed-up shared buffers prewarming

2023-03-16 Thread Drouvot, Bertrand
Hi, On 3/15/23 10:40 PM, Matthias van de Meent wrote: On Wed, 15 Mar 2023 at 21:38, Konstantin Knizhnik wrote: Hi hackers, It is well known fact that queries using sequential scan can not be used to prewarm cache, because them are using ring buffer even if shared buffers are almost empty. I

Re: Speed-up shared buffers prewarming

2023-03-15 Thread Melanie Plageman
On Wed, Mar 15, 2023 at 4:38 PM Konstantin Knizhnik wrote: > It is well known fact that queries using sequential scan can not be used to > prewarm cache, because them are using ring buffer > even if shared buffers are almost empty. > I have searched hackers archive but failed to find any discussi

Re: Speed-up shared buffers prewarming

2023-03-15 Thread Matthias van de Meent
On Wed, 15 Mar 2023 at 21:38, Konstantin Knizhnik wrote: > > Hi hackers, > > It is well known fact that queries using sequential scan can not be used to > prewarm cache, because them are using ring buffer > even if shared buffers are almost empty. > I have searched hackers archive but failed to f

Speed-up shared buffers prewarming

2023-03-15 Thread Konstantin Knizhnik
Hi hackers, It is well known fact that queries using sequential scan can not be used to prewarm cache, because them are using ring buffer even if shared buffers are almost empty. I have searched hackers archive but failed to find any discussion about it. What are the drawbacks of using free buf