Postgres Pro
Downloads
Home   >   mailing lists

Re: R: slow seqscan after vacuum analize - Mailing list pgsql-admin

From David F. Skoll
Subject Re: R: slow seqscan after vacuum analize
Date
Msg-id Pine.LNX.4.58.0402042115370.6678@shishi.roaringpenguin.com
Whole thread Raw
In response to R: slow seqscan after vacuum analize  ("Edoardo Ceccarelli" <eddy@axa.it>)
Responses R: R: slow seqscan after vacuum analize  ("Edoardo Ceccarelli" <eddy@axa.it>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: "Edoardo Ceccarelli"
Date:
Subject: R: R: slow seqscan after vacuum analize
Next
From: "Edoardo Ceccarelli"
Date:
Subject: R: R: slow seqscan after vacuum analize