On Tuesday 19 December 2006 17:13, Magnus Hagander wrote:
> John Hansen wrote:
> > Magnus Hagander Wrote:
> >>> Archives search is slow. (5+ seconds to search all lists)
> >>
> >> Depends on what you search for ;-) What did you search for?
> >
> > 'create table'
>
> Yeah, that one is definitely the sort. Just the search over all lists
> for create table takes about 170ms and returns about 6000 hits.
> Calculating rank value and sorting it takes the rest :(
>
Maybe we could add a "click here to see the explain analyze of your search
query" button. :-)
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL