On Thu, 5 Feb 2004, Edoardo Ceccarelli wrote:
> Things are worst only for seqscan, when it uses indexscan timing is good.
It might just be that running VACUUM flushed the operating system's
buffer cache.
I always try running two or three EXPLAIN ANALYZE's in a row for the
same query. Usually, the first one takes much longer than the rest.
Regards,
David.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
