Postgres Pro
Downloads
Home   >   mailing lists

Re: Query is slow when run for first time; subsequent execution is fast - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Query is slow when run for first time; subsequent execution is fast
Date
Msg-id CAMkU=1xufgsgEL148=c+Bu-BMYzQy12X2YASdKAXoz5ns5bz4w@mail.gmail.com
Whole thread Raw
In response to RE: Query is slow when run for first time; subsequent execution isfast  (jimmy <mpokky@126.com>)
List pgsql-performance
Tree view
On Tue, Sep 4, 2018 at 3:16 AM jimmy <mpokky@126.com> wrote:
On windows, how to put an entry in my db startup script to run this query （pg_prewarm） immediately after startng the server, and let the query warm the cache itself.

Starting with PostgreSQL version 11 (to be released soon), you can use  pg_prewarm.autoprewarm.


I've tested neither one.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Inconsistent query times and spiky CPU with GIN tsvector search
Next
From: Dinesh Kumar
Date:
Subject: Re: Performance difference in accessing differrent columns in aPostgres Table