=?ISO-8859-1?Q?G=E1bor_Farkas?= <ga...@nekomancer.net> writes:
> i have a query that uses a Hash-Join, but it would be faster with Nested-Loop,
> and i don't know how to persuade postgresql to do it.
Fix the way-off-base rowcount estimates ...
> postgresql-8.2 + tsearch2
... which is just about impossible in 8.2, because there's no
statistical support for @@ selectivity estimation. Consider
updating to 8.4.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
