X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1FC5730F89A for ; Tue, 24 Jun 2003 08:20:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 59944-05 for ; Tue, 24 Jun 2003 05:20:41 -0300 (ADT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 0DF1830F7A0 for ; Tue, 24 Jun 2003 05:20:40 -0300 (ADT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h5O8Kdt22612 for ; Tue, 24 Jun 2003 13:50:39 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h5O8KdH22607 for ; Tue, 24 Jun 2003 13:50:39 +0530 From: "Shridhar Daithankar" To: Date: Tue, 24 Jun 2003 13:49:54 +0530 MIME-Version: 1.0 Subject: Re: Performance advice Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3EF85702.30194.3A69859@localhost> In-reply-to: <3EF85224.1633.3939548@localhost> References: X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Archive-Number: 200306/137 X-Sequence-Number: 2221 On 24 Jun 2003 at 13:29, Shridhar Daithankar wrote: > > - I have at my disposal one other server which has 2 Xeons, 10,000 RPM SCSI > > drive. Would it make sense to put Postgres on it and leave my apps running > > on the more powerful 4 CPU server? Argh.. Forgot it first time. With java runnning on same machine, I would not trust that machine for having free RAM all the time, no matter how much RAM you have put into it. Secondly you are running linux which is known to have weird behaviour problems when it runs low on memory. For both these reasons, I suggest you put your database on another machine. A dual CPU machine is more than enough. Put good deal RAM, around a GB and two SCSI disks, one for data and another for WAL. If you get RAID for data, great. But that should suffice otherwise as well. > > > > - Would a RAID setup make the disk faster? Because top rarely shows the > > CPUs above 50%, I suspect maybe the disk is the bottleneck. > > Yes it is. You need to move WAL to a different disk. Even if it is IDE. (OK > that was over exaggeration but you got the point). If your data directories and > WAL logs are on physically different disks, that should bump up performance > plenty. In addition to that, on linux, it matters a lot as in what filesystem you use. IMO ext3 is strict no-no. Go for either reiserfs or XFS. There is no agreement as in which file system is best on linux. so you need to experiment if you need every ounce of performance. And for that you got to try freeBSD. That would gave you plenty of idea about performance differences. ( Especially I love man hier and man tuning on freeBSD. Nothing on linux comes anywhere near to that) Bye Shridhar -- "Who is General Failure and why is he reading my hard disk ?"Microsoft spel chekar vor sail, worgs grate !!(By leitner@inf.fu-berlin.de, Felix von Leitner)