Re: Erratically behaving query needs optimization

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Barbu Paul - Gheorghe <barbu(dot)paul(dot)gheorghe(at)gmail(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Erratically behaving query needs optimization
Date: 2019-08-26 11:51:41
Message-ID: 20190826115141.GE7201@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)janes(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2019-09-02 21:57:17 Re: Erratically behaving query needs optimization
Previous Message Barbu Paul - Gheorghe 2019-08-26 08:25:57 Re: Erratically behaving query needs optimization