Tom Lane wrote:
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
ok, i thought it would be something gist specific i was not aware of.
the golden question now is: i am looking for the cheapest products given
a certain text in an insane amount of data.
how to do it? other quals which could narrow down the amount of data
would not help.
i cannot see an option with regular "weapons" ...
maybe you can an idea how to fix core to make it work? maybe there is a
mechanism we could need.
we really have to make this work - no matter what it takes.
we are willing to put effort into that.
many thanks,
hans
--
Cybertec Schoenig & Schoenig GmbH
Reyergasse 9 / 2
A-2700 Wiener Neustadt
Web: www.postgresql-support.de
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
