Manfred Koizar <[EMAIL PROTECTED]> writes:
> So statistics gathering for expressional indexes will be in 7.5, but I
> don't know about the state of the planner ...

Planner support is there too:

2004-02-16 19:52  tgl

        * src/: backend/optimizer/path/costsize.c,
        backend/optimizer/util/relnode.c, backend/utils/adt/selfuncs.c,
        include/optimizer/pathnode.h, include/utils/selfuncs.h: Make use of
        statistics on index expressions.  There are still some corner cases
        that could stand improvement, but it does all the basic stuff.  A
        byproduct is that the selectivity routines are no longer
        constrained to working on simple Vars; we might in future be able
        to improve the behavior for subexpressions that don't match
        indexes.

I don't recall anymore what "corner cases" I had in mind for future
improvement.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to