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'
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;