=?ISO-8859-1?Q?G=E1bor_Farkas?= <gabor(at)nekomancer(dot)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