Skip site navigation (1) Skip section navigation (2)

Re: combined indexes with Gist - planner issues?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hans-Juergen Schoenig -- PostgreSQL <postgres(at)cybertec(dot)at>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Zoltan Boszormenyi <zb(at)cybertec(dot)at>
Subject: Re: combined indexes with Gist - planner issues?
Date: 2009-08-31 13:54:01
Message-ID: 543.1251726841@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Jean-Paul ArgudoDate: 2009-08-31 13:59:40
Subject: Feature request : add REMAP_SCHEMA-like option to pg_restore
Previous:From: Werner EchezuriaDate: 2009-08-31 13:43:51
Subject: Bison crashes postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group