Hi,

Bruce Momjian ha scritto:
Uh, I just moved the selectivity function over to /contrib/ltree, and
moved what I needed, so it now works.  You can continue with the plan
above, or I can.


I've just been able to install a 8.2-devel to test the ltree selectivity improvements I suggested.

It was a big surprise having no improvements at all in the query I used for all my previous tests, until I found out that the test against histogram values was removed by Tom. I strongly think it should be reintroduced: ltree columns are likely to have a unique constraint and the current ltreeparentsel function will behave just like contsel in these cases.

Here is the commit:

Log Message:
-----------
Fix ltreeparentsel so it actually works ...

Modified Files:
--------------
    pgsql/contrib/ltree:
        ltree_op.c (r1.10 -> r1.11)
        
(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltree_op.c.diff?r1=1.10&r2=1.11)



Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to