Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 17 Jan 2008 16:09:28 -0500
From:      Robert Fitzpatrick <lists@webtent.net>
To:        Bill Moran <wmoran@potentialtech.com>
Cc:        FreeBSD <freebsd-questions@freebsd.org>
Subject:   Re: db performance
Message-ID:  <1200604168.7281.65.camel@columbus.webtent.org>
In-Reply-To: <20080117155336.0c38d86d.wmoran@potentialtech.com>
References:  <1200602606.7281.48.camel@columbus.webtent.org> <20080117155336.0c38d86d.wmoran@potentialtech.com>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
On Thu, 2008-01-17 at 15:53 -0500, Bill Moran wrote:
> In response to Robert Fitzpatrick <lists@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




Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?1200604168.7281.65.camel>