Oleg Bartunov <oleg@sai.msu.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