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