Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query using simple equality operators - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow query using simple equality operators
Date
Msg-id 17536.1177373573@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow query using simple equality operators  (Benjamin Arai <benjamin@araisoft.com>)
Responses Re: Slow query using simple equality operators  (Benjamin Arai <benjamin@araisoft.com>)
List pgsql-general
Tree view 
Benjamin Arai <benjamin@araisoft.com> writes:
> To follow up on my own email, by disabling BitmapScan in my
> postgresql.conf the performance seems to be better. Is something
> wrong with the query analyzer?

I just rewrote choose_bitmap_and() to fix some issues that might be
related to this; please try your query with 8.2.4 or 8.1.9 as the
case may be (and next time, mention what version you're using
right off the bat).

            regards, tom lane

pgsql-general by date:

Previous
From: Benjamin Arai
Date:
Subject: Re: Slow query using simple equality operators
Next
From: "George Pavlov"
Date:
Subject: PG service restart failure (start getting ahead of stop?)