On 24/10/10 14:44, Sushant Sinha wrote: > I am using gin index on a tsvector and doing basic search. I see the > row-estimate of the planner to be horribly wrong. It is returning > row-estimate as 4843 for all queries whether it matches zero rows, a > medium number of rows (88,000) or a large number of rows (726,000). > > The table has roughly a million docs. > > I see a similar problem reported here but thought it was fixed in 9.0 > which I am running.
Hi, what's your default statistics target? Could you attach the output of select * from pg_stats where tablename = '<the-tablename>'; and select typanalyze from pg_type where typname = 'tsvector'; Thanks, Jan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
