Re: website doc search is extremely SLOW - Mailing list pgsql-general

On Wed, 31 Dec 2003, Dave Cramer wrote:

> I can modify mine to be client server if you want?
>
> It is a java app, so we need to be able to run jdk1.3 at least?

jdk1.4 is available on the VMs ... does your spider?  for instance, you
mention that you have the docs indexed right now, but we are currently
indexing:

Server http://archives.postgresql.org/
Server http://advocacy.postgresql.org/
Server http://developer.postgresql.org/
Server http://gborg.postgresql.org/
Server http://pgadmin.postgresql.org/
Server http://techdocs.postgresql.org/
Server http://www.postgresql.org/

will it be able to handle:

186_archives=# select count(*) from url;
 count
--------
 393551
(1 row)

as fast as you are finding with just the docs?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664