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
In response to
pgsql-hackers by date
|Next:||From: Jean-Paul Argudo||Date: 2009-08-31 13:59:40|
|Subject: Feature request : add REMAP_SCHEMA-like option to pg_restore|
|Previous:||From: Werner Echezuria||Date: 2009-08-31 13:43:51|
|Subject: Bison crashes postgresql|