pgsql/src include/optimizer/paths.h backend/op ...

From: Tom Lane <tgl(at)hub(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql/src include/optimizer/paths.h backend/op ...
Date: 2001-06-05 17:13:52
Message-ID: 200106051713.f55HDqY09910@hub.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

CVSROOT: /home/projects/pgsql/cvsroot
Module name: pgsql
Changes by: tgl(at)hub(dot)org 01/06/05 13:13:52

Modified files:
src/include/optimizer: paths.h
src/backend/optimizer/path: allpaths.c indxpath.c orindxpath.c

Log message:
Improve planning of OR indexscan plans: for quals like
WHERE (a = 1 or a = 2) and b = 42
and an index on (a,b), include the clause b = 42 in the indexquals
generated for each arm of the OR clause. Essentially this is an index-
driven conversion from CNF to DNF. Implementation is a bit klugy, but
better than not exploiting the extra quals at all ...

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2001-06-05 19:34:56 pgsql/src include/utils/acl.h backend/utils/ad ...
Previous Message Peter Eisentraut 2001-06-05 17:06:01 Re: pgsql/ oc/src/sgml/ref/create_function.sgml rc ...