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

From Tom Lane
Subject Re: Strangely Variable Query Performance
Date
Msg-id 10067.1176420549@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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:
> Here's my planner parameters:

I copied all these, and my 8.2.x still likes the bitmap scan a lot
better than the seqscan.  Furthermore, I double-checked the CVS history
and there definitely haven't been any changes in that area in REL8_2
branch since 8.2.3.  So I'm a bit baffled.  Maybe the misbehavior is
platform-specific ... what are you on exactly?  Is there anything
nonstandard about your Postgres installation?

            regards, tom lane

pgsql-performance by date:

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