Re: GiST index not used for ORDER BY?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Max <mail(at)to-the-max(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: GiST index not used for ORDER BY?
Date: 2005-01-27 22:50:55
Message-ID: 16653.1106866255@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> On Thu, 27 Jan 2005, Max wrote:
>> The basic idea is: a user enters a search query and a maximum of 1000 results
>> is returned, sorted by date, newest first.

> I assume you already vacuum your db. Hmm, seems you need to rewrite your query.

That's not going to help. GiST doesn't support ordered retrieval does it?
The planner certainly doesn't think so, because pg_am says not.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2005-01-27 22:57:22 changing sort_mem on the fly?
Previous Message David Fetter 2005-01-27 22:48:47 Re: Oracle and PostgreSQL