Re: Search engine

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: John Hansen <john(at)geeknet(dot)com(dot)au>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: Search engine
Date: 2006-12-19 13:04:23
Message-ID: 20061219130423.GA10269@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

On Tue, Dec 19, 2006 at 07:01:34PM +1100, John Hansen wrote:
> Two things:
>
> Navigate to http://www.postgresql.org/docs/8.2/static/index.html and search for 'create table'
>
> Pages 1-20 of 247.
>
> Click 'next'
>
> Pages 21-40 of more than 1000.
>
> Obviously, the hyperlinks need to include the &u=/docs/8.2/static/

Should be fixed now, thanks for pointing it out.

> Archives search is slow. (5+ seconds to search all lists)

Depends on what you search for ;-) What did you search for?

The problem is that the search is very fast (single-digit millisecond
much of time), but if you get several thousand hits it takes a while to
sort them.
It could also be that you search for something that had been forced out
of the cache - happens for example when the backups run. Then the first
search takes a while, but it goes faster with time.

> Apart from that, bloody good work. Thumbs up.

Thanks!

//Magnus

In response to

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Magnus Hagander 2006-12-19 13:13:35 Re: Search engine
Previous Message Robert Treat 2006-12-19 12:50:21 Re: Downtime completed ... about 3 hours ago ...