Matteo Beccati <[EMAIL PROTECTED]> writes:
> 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.

The histogram values seem completely meaningless in this context ---
for containment purposes, they are just ten or so randomly chosen
values.  I don't believe that the estimator works better with them.
Certainly, whether the column is unique or not is totally irrelevant
to whether they are representative.

What would seem saner to me is to add a datatype-specific analyze
function that collects some statistics that are actually relevant
to containment, and then make use of those in the estimator.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to