Re: Query is slow when run for first time; subsequent execution is fast

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Query is slow when run for first time; subsequent execution is fast
Дата
Msg-id CAMkU=1xufgsgEL148=c+Bu-BMYzQy12X2YASdKAXoz5ns5bz4w@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Query is slow when run for first time; subsequent execution isfast  (jimmy <mpokky@126.com>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Inconsistent query times and spiky CPU with GIN tsvector search
Следующее
От: Dinesh Kumar
Дата:
Сообщение: Re: Performance difference in accessing differrent columns in aPostgres Table