Re: R: slow seqscan after vacuum analize

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: Edoardo Ceccarelli <eddy(at)axa(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: R: slow seqscan after vacuum analize
Date: 2004-02-05 02:17:02
Message-ID: Pine.LNX.4.58.0402042115370.6678@shishi.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edoardo Ceccarelli 2004-02-05 02:18:31 R: R: slow seqscan after vacuum analize
Previous Message Edoardo Ceccarelli 2004-02-05 02:10:13 R: R: slow seqscan after vacuum analize