Re: How to track down inconsistent performance? - Mailing list pgsql-general

From Ron Snyder
Subject Re: How to track down inconsistent performance?
Date
Msg-id F888C30C3021D411B9DA00B0D0209BE8026E303A@cvo-exchange.cvo.roguewave.com
Whole thread Raw
In response to How to track down inconsistent performance?  (Ron Snyder <snyder@roguewave.com>)
Responses Re: How to track down inconsistent performance?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> affect that).  I would think that a seqscan would be faster for this.
> I would definitely think that the planner would think so --- are you
> forcing enable_seqscan off?

Forgot to answer this-- no, we're not forcing it off.  Maybe we need to
force it to use a seqscan for this query?


> Since you're evidently running 7.2, I'd ask for EXPLAIN ANALYZE rather

We are still running 7.2 on this database-- we're in the middle of
acceptance testing for the 7.2.1 upgrade.

-ron


pgsql-general by date:

Previous
From: Ron Snyder
Date:
Subject: Re: How to track down inconsistent performance?
Next
From: Tom Lane
Date:
Subject: Re: JOINing subselects in FROM?