Re: [HACKERS] Interesting optimizer's supposition in 8.1

2005-10-05 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > Why planner suppose that t 'table' will return 1000 rows? Because set_function_size_estimates() is only a stub :-( regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9'

[HACKERS] Interesting optimizer's supposition in 8.1

2005-10-05 Thread Teodor Sigaev
Tsearch2 has function to_tsquery defined as: CREATE FUNCTION to_tsquery(oid, text) RETURNS tsquery AS '$libdir/tsearch2' LANGUAGE 'c' with (isstrict,iscachable); And let we take 2 essential equivalent queries: # explain select book.id from to_tsquery('foo') as t, book where book.fts @@ t;