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

From Jeff Davis
Subject Re: Queryplan within FTS/GIN index -search.
Date
Msg-id 1256325723.28858.60.camel@monkey-cat.sm.truviso.com
Whole thread Raw
In response to Re: Queryplan within FTS/GIN index -search.  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
On Fri, 2009-10-23 at 17:27 +0100, Richard Huxton wrote:
> Returns an array of keys given a value to be queried; that is, query is
> the value on the right-hand side of an indexable operator whose
> left-hand side is the indexed column
>
> So - that is presumably two separate arrays of keys being matched
> against, and the AND means if the first fails it'll never check the second.

My point was that if it's only one index scan in both cases, then GIN
should have the same information in both cases, right? So why are they
being treated differently?

I must be missing something.

Regards,
    Jeff Davis


pgsql-performance by date:

Previous
From: Kevin Buckham
Date:
Subject: Re: Table Clustering & Time Range Queries
Next
From: Jesper Krogh
Date:
Subject: Re: Calculating selectivity for the query-planner on ts_vector colums.