=?ISO-8859-1?Q?G=E1bor_Farkas?= <gabor@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
