db performance

[Robert Fitzpatrick]

On Thu, 2008-01-17 at 15:53 -0500, Bill Moran wrote:
> In response to Robert Fitzpatrick <lists at webtent.net>:
> 
> > I also have assumed in the past that db performance could be better if I
> > get off the system RAID-5 and put it on 1+0? The system has 4 SATA
> > drives.
> 
> That will speed things up if IO is your bottleneck, but you've not
> demonstrated that.
> 
> Which machine in this system is the bottleneck?  Are the Amavis machines
> timing out, or is the PostgreSQL server too slow?  If I understand your
> description, it sounds like a network problem to me ... i.e., machines
> not on the same gateway as the PG server are experience slow network
> response (or dropped packets?) that's causing amavis to time out while
> trying to talk to PG.  I would suggest investigating there first.
> 

The SA timeouts I'm finding on all the servers. Even the db server that
runs it's own amavisd process for backup purposes and some minor domains
just to make sure it is there and working. This is why I think you're
right, the pgsql db is too slow. Would I possibly see dramatic
differences in speed with the RAID switch?

-- 
Robert