Query only slow on first run

Поиск
Список
Период
Сортировка
От cluster
Тема Query only slow on first run
Дата
Msg-id fihgt1$1mmh$1@news.hub.org
обсуждение исходный текст
Ответы Re: Query only slow on first run  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Query only slow on first run  (Kevin Kempter <kevin@kevinkempterllc.com>)
Список pgsql-performance
I have a query that takes about 7000 ms in average to complete the first
time it runs. Subsequent runs complete in only 50 ms. That is more than
a factor 100 faster! How can I make the query perform good in the first
run too?

Query and output from both first and second run of Explain Analyze is
pasted here:

http://rafb.net/p/yrKyoA17.html

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: 8.1 planner problem ?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Query only slow on first run