Oleg Bartunov <[email protected]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])