Re: Strangely Variable Query Performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Strangely Variable Query Performance
Date
Msg-id 5772.1176413092@sss.pgh.pa.us
Whole thread Raw
In response to Strangely Variable Query Performance  (Steve <cheetah@tanabi.org>)
Responses Re: Strangely Variable Query Performance  (Steve <cheetah@tanabi.org>)
List pgsql-performance
Steve <cheetah@tanabi.org> writes:
> On a Postgres 8.2.3 server, I've got a query that is running very slow in
> some cases.

Could we see the exact definition of that table and its indexes?
It looks like the planner is missing the bitmap scan for some reason,
but I've not seen a case like that before.

Also, I assume the restriction on receipt date is very nonselective?
It doesn't seem to have changed the estimated rowcount much.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve
Date:
Subject: Strangely Variable Query Performance
Next
From: Steve
Date:
Subject: Re: Strangely Variable Query Performance