Hans-Juergen Schoenig -- PostgreSQL <postgres(at)cybertec(dot)at> 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