Re: [SQL] problem with OR'ed AND queriess - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] problem with OR'ed AND queriess
Date
Msg-id 14561.945836032@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] problem with OR'ed AND queriess  (Michael McCarthy <michael@tcsi.com>)
List pgsql-sql
Michael McCarthy <michael@tcsi.com> writes:
> A quick examination of backend/optimizer/prep/prepkeyset.c shows me that
> there is some qualification of a query for keyset optimization; is there
> any reason why I should not always set ksqo on?

If it seems to win more often than not for your query mix, go for it.

ksqo is a hack that I'm hoping to eliminate in the next release or
three.  But right now, it's a mighty useful hack if you do a lot of
OR-of-AND queries...
        regards, tom lane


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] problem with OR'ed AND queriess
Next
From: "Bron Till"
Date:
Subject: