Skip site navigation (1) Skip section navigation (2)

Re: performace about your search engine

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: mscsathya(at)yahoo(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: performace about your search engine
Date: 2000-11-03 04:17:37
Message-ID: Pine.BSF.4.21.0011030014030.494-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, 2 Nov 2000 pgsql-bugs(at)postgresql(dot)org wrote:

> P. Ashok Kumar (mscsathya(at)yahoo(dot)com) reports a bug with a severity of 2
> The lower the number the more severe it is.
> 
> Short Description
> performace about your search engine
> 
> Long Description

> You search engine takes long time to give results. Many times It's
> session is timed out.

we have new hardware on order to rectify this problem, assuming that I've
been able to properly identify where the bottleneck is.  After doing some
research on the existing system, and spending some time talking with some
of the FreeBSD SCSI developers, it turns out that the SCSI drives on the
database server that is managing the search engine data are pretty much
saturated.  This is with the search engine data spread over 2 SCSI drives
... we've ordered in 2 9gig drives to spread the data over more, as well
as have a 3rd drive that used to be in that machine that is off under RMA,
giving us 5 spindles to spread the data load over ...

we *hope* to have the 2 new drives installed late tomorrow, if all goes
well and they get in *cross fingers*



In response to

pgsql-bugs by date

Next:From: Chau, ArtemisDate: 2000-11-03 15:18:07
Subject: FATAL 1: btree
Previous:From: Tom LaneDate: 2000-11-03 01:05:48
Subject: Re: psql client segfault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group