Re: combined indexes with Gist - planner issues?

Hans-Juergen Schoenig -- PostgreSQL  writes:
> what we basically expected here is that Postgres will scan the table 
> using the index to give us the cheapest products containing the words we 
> are looking for.
> i am totally surprised to see that we have to fetch all products given 
> the words, sort and then do the limit.

I don't know why you'd find that surprising.  GIST indexes have no
support for ordering.
		regards, tom lane