Re: combined indexes with Gist - planner issues? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: combined indexes with Gist - planner issues?
Date
Msg-id 543.1251726841@sss.pgh.pa.us
Whole thread Raw
In response to combined indexes with Gist - planner issues?  (Hans-Juergen Schoenig -- PostgreSQL <postgres@cybertec.at>)
Responses Re: combined indexes with Gist - planner issues?  (Hans-Juergen Schoenig -- PostgreSQL <postgres@cybertec.at>)
List pgsql-hackers
Hans-Juergen Schoenig -- PostgreSQL <postgres@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


pgsql-hackers by date:

Previous
From: Werner Echezuria
Date:
Subject: Bison crashes postgresql
Next
From: Jean-Paul Argudo
Date:
Subject: Feature request : add REMAP_SCHEMA-like option to pg_restore