X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8E09FD1C983 for ; Fri, 8 Aug 2003 10:28:36 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 13705-03 for ; Fri, 8 Aug 2003 07:27:12 -0300 (ADT) Received: from beth.coza.net.za (beth.coza.net.za [206.223.136.193]) by svr1.postgresql.org (Postfix) with ESMTP id 11908D1C4B9 for ; Fri, 8 Aug 2003 07:28:15 -0300 (ADT) Received: from coza.net.za (mixo.coza.net.za [206.223.136.225]) by beth.coza.net.za (8.11.6/8.11.2) with ESMTP id h78AS3o21213 for ; Fri, 8 Aug 2003 12:28:03 +0200 Message-ID: <3F337B39.5030904@coza.net.za> Date: Fri, 08 Aug 2003 12:28:09 +0200 From: mixo User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030225 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Perfomance Tuning Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/148 X-Sequence-Number: 2965 I have just installed redhat linux 9 which ships with Pg 7.3.2. Pg has to be setup so that data inserts (blobs) should be able to handle at least 8M at a time. The machine has two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and a 36 Gig hd with 1 Gig swap and 3 equal size ext3 partitions. What would be the recomended setup for good performance considering that the db will have about 15 users for 9 hours in a day, and about 10 or so users throughout the day who wont be conistenly using the db.