X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id BC128D1C924 for ; Mon, 21 Jul 2003 08:50:13 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 65044-05 for ; Mon, 21 Jul 2003 08:50:12 +0000 (GMT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 5A516D1C923 for ; Mon, 21 Jul 2003 05:50:10 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h6L8tFfL029097 for ; Mon, 21 Jul 2003 14:25:15 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by smtp.pspl.co.in (8.12.9/8.12.9) with ESMTP id h6L8tF6O029084 for ; Mon, 21 Jul 2003 14:25:15 +0530 From: "Shridhar Daithankar" To: Date: Mon, 21 Jul 2003 14:21:53 +0530 MIME-Version: 1.0 Subject: Re: Tuning PostgreSQL Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F1BF701.248.144C5B84@localhost> In-reply-to: <002a01c34f62$75c01de0$b696a8c0@APR> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/322 X-Sequence-Number: 2615 On 21 Jul 2003 at 10:31, Alexander Priem wrote: > What I am thinking about is buying a server with the following specifications: > > * 1 or 2 Intel Xeon processors (2.4 GHz). > * 2 Gigabytes of RAM (DDR/ECC). > * Three 36Gb SCSI160 disks (10.000rpm) in a RAID-5 config, giving 72Gb storage > space (right?). The RAID-5 controller has a(hardware) cache of 128Mb. > * 100Mbit ethernet. > > I will run RedHat Linux 9 (kernel 2.40) with PostgreSQL 7.3.3 on this server. You might scale down a little on hardware front if required. Of course, if you can get it, get it. > What would you think of this hardware config? Would it do? Of would 4Gb RAM be > a lot better? What do you think about the need for two Xeon procs? I would say get an SMP board with one processor in it. If requierd you can upgrade. I suppose that would make hefty difference in price. > shared_buffers = 6000(kernel.shmmax = 60000000) > sort_mem = 4096 > max_connections = 150 > vacuum_mem = 65536 effective_cache_size noatime for data partition A good filesystem. WAL on separate drive. Now that is a good start.. Bye Shridhar -- QOTD: "I'm on a seafood diet -- I see food and I eat it."