Yes, you are right but it wasn't the case this time, I have run the explain plenty of times with same results. I think that the reason was that I made a simple VACUUM, after a VACUUM FULL ANALYZE (1h!!) things are ok
Best Regards Edoardo > -----Messaggio originale----- > Da: David F. Skoll [mailto:[EMAIL PROTECTED] > Inviato: giovedì 5 febbraio 2004 3.17 > A: Edoardo Ceccarelli > Cc: [EMAIL PROTECTED] > Oggetto: Re: R: [ADMIN] slow seqscan after vacuum analize > > 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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
