Re: Erratically behaving query needs optimization - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Erratically behaving query needs optimization
Date
Msg-id 20190826115141.GE7201@telsasoft.com
Whole thread Raw
In response to Re: Erratically behaving query needs optimization  (Barbu Paul - Gheorghe <barbu.paul.gheorghe@gmail.com>)
List pgsql-performance
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 <jeff.janes@gmail.com> 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 ends
> from 2013 from which I gather it only works on Linux.

It's a current extension - spelled PREwarm, not rewarm, and definitely not
reworm.

https://www.postgresql.org/docs/current/pgprewarm.html



pgsql-performance by date:

Previous
From: Barbu Paul - Gheorghe
Date:
Subject: Re: Erratically behaving query needs optimization
Next
From: Jeff Janes
Date:
Subject: Re: Erratically behaving query needs optimization