Re: Queryplan within FTS/GIN index -search. - Mailing list pgsql-performance

On Fri, 2009-10-23 at 09:26 +0100, Richard Huxton wrote:
> That structure isn't exposed to the planner though, so it doesn't
> benefit from any re-ordering the planner would normally do for normal
> (exposed) AND/OR clauses.

I don't think that explains it, because in the second plan you only see
a single index scan with two quals:

   Index Cond: ((ftsbody_body_fts @@
     to_tsquery('commonterm'::text)) AND (ftsbody_body_fts @@
     to_tsquery('spellerror'::text)))

So it's entirely up to GIN how to execute that.

Regards,
    Jeff Davis