[GENERAL] GiST index not used for ORDER BY?

Hi, I'm setting up a simple search engine using Tsearch2. The basic idea is: a user enters a search query and a maximum of 1000 results is returned, sorted by date, newest first. At the moment the table holding the searchable data has 1.1 million entries. It works great when the search only

Re: [GENERAL] GiST index not used for ORDER BY?

On Thu, 27 Jan 2005, Max wrote: Hi, I'm setting up a simple search engine using Tsearch2. The basic idea is: a user enters a search query and a maximum of 1000 results is returned, sorted by date, newest first. At the moment the table holding the searchable data has 1.1 million entries. It works

Re: [GENERAL] GiST index not used for ORDER BY?

Hi, At 09:54 PM 1/27/2005, you wrote: On Thu, 27 Jan 2005, Max wrote: I'm setting up a simple search engine using Tsearch2. The basic idea is: a user enters a search query and a maximum of 1000 results is returned, sorted by date, newest first. At the moment the table holding the searchable data

Re: [GENERAL] GiST index not used for ORDER BY?

On Thu, 27 Jan 2005, Max wrote: Hi, At 09:54 PM 1/27/2005, you wrote: On Thu, 27 Jan 2005, Max wrote: I'm setting up a simple search engine using Tsearch2. The basic idea is: a user enters a search query and a maximum of 1000 results is returned, sorted by date, newest first. At the moment the

Re: [GENERAL] GiST index not used for ORDER BY?

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