Skip site navigation (1)
Skip section navigation (2)
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?
Peripheral Links
Header And Logo
|
Site Navigation
Query only slow on first run
- From: cluster <skrald(at)amossen(dot)dk>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Query only slow on first run
- Date: Tue, 27 Nov 2007 17:33:36 +0100
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
- Follow-Ups:
- Re: Query only slow on first run
- From: Kevin Kempter
- Re: Query only slow on first run
- From: Andrew Sullivan
- Re: Query only slow on first run
- Prev by Date: Re: 8.1 planner problem ?
- Next by Date: Re: Query only slow on first run
- Previous by thread: 8.1 planner problem ?
- Next by thread: Re: Query only slow on first run
- Indexes: