Re: Erratically behaving query needs optimization

2019-08-26 Thread Justin Pryzby
On Mon, Aug 26, 2019 at 11:25:57AM +0300, Barbu Paul - Gheorghe wrote: > On Sun, Aug 25, 2019 at 5:51 PM Jeff Janes wrote: > > > You can use pg_rewarm to overcome the cold cache issue when you first start > > up the server. > > I cannot find anything related to pg_rewarm other than some dead en

Re: Erratically behaving query needs optimization

2019-08-26 Thread Barbu Paul - Gheorghe
On Sun, Aug 25, 2019 at 5:51 PM Jeff Janes wrote: > > Yes, it certainly looks like it is due to cold caches. But you say it is > slow at first, and then say it varies greatly during a run. Is being slow at > first the only way it varies greatly, or is there large variation even beyond > that?