Hans-Juergen Schoenig -- PostgreSQL <postg...@cybertec.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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
