Re: [GENERAL] System Load analyze

2007-11-28 Thread Greg Smith
On Wed, 28 Nov 2007, Peter Bauer wrote: PERC4E/DI DC ULTRA320 SCSI RAID, 256MB Its Debian sarge with kernel 2.4.26.050719-686 #1 SMP. OK, so I'd expect you're using the megaraid2 driver. That and kernel 2.4.26 are a few years behind current at this point, and there have been plenty of perfo

Re: [GENERAL] System Load analyze

2007-11-28 Thread Peter Bauer
Hi Greg, Am Mittwoch 28 November 2007 schrieb Greg Smith: > On Sat, 24 Nov 2007, Peter Bauer wrote: > > top shows that the CPUs are at least 80% idle most of the time so i > > think there is an I/O bottleneck. > > top also shows that you're never waiting for I/O which is usually evidence > there i

Re: [GENERAL] System Load analyze

2007-11-28 Thread Greg Smith
On Sat, 24 Nov 2007, Peter Bauer wrote: top shows that the CPUs are at least 80% idle most of the time so i think there is an I/O bottleneck. top also shows that you're never waiting for I/O which is usually evidence there isn't an I/O bottleneck. You passed along most of the right data, bu

Re: [GENERAL] System Load analyze

2007-11-27 Thread Peter Bauer
Am Dienstag 27 November 2007 schrieb Scott Marlowe: > On Nov 24, 2007 10:57 AM, Peter Bauer <[EMAIL PROTECTED]> wrote: > > i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on > > a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 > > running with the data on a DR

Re: [GENERAL] System Load analyze

2007-11-27 Thread Scott Marlowe
On Nov 24, 2007 10:57 AM, Peter Bauer <[EMAIL PROTECTED]> wrote: > > i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on > a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 > running with the data on a DRBD Device for High Availability. The used > database is al

[GENERAL] System Load analyze

2007-11-27 Thread Peter Bauer
Hi all, i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 running with the data on a DRBD Device for High Availability. The used database is also replicated to two similar machines with slony1. Since the loa

Re: [GENERAL] System Load analyze

2007-11-25 Thread Pavel Stehule
Hello maybe you have to tune bgwriter. Please, read this article http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Regards Pavel Stehule On 25/11/2007, Peter Bauer <[EMAIL PROTECTED]> wrote: > > Hi all, > > i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on

[GENERAL] System Load analyze

2007-11-25 Thread Peter Bauer
Hi all, i have a system here with 2 2.4GHz Xeon Processors, 2GB RAM, ONE Disk on a Battery Backed Write Cache SCSI Controller and PostgreSQL 8.1.4 running with the data on a DRBD Device for High Availability. The used database is also replicated to two similar machines with slony1. Since the loa