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

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Query is slow when run for first time; subsequent execution isfast
Дата
Msg-id d46ddd88-6eaf-33a0-0b7b-672b5316262e@gmx.net
обсуждение исходный текст
Ответ на Re: Query is slow when run for first time; subsequent execution is fast  (Nandakumar M <m.nanda92@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Nandakumar M schrieb am 12.01.2018 um 09:03:
> Even if I close a connection and open a new one and execute the same
> query, the planning time is considerably less than the first time.
> Only when I restart the Postgres server then I face high planning
> time again.

Yes, because the data is cached by Postgres ("shared_buffers") and the filesystem.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Nandakumar M
Дата:
Сообщение: Fwd: Re: Query is slow when run for first time; subsequent executionis fast
Следующее
От: Nicolas Charles
Дата:
Сообщение: Re: HDD vs SSD without explanation