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 651FCD1C983 for ; Fri, 8 Aug 2003 11:29:27 +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 11452-09 for ; Fri, 8 Aug 2003 08:28:03 -0300 (ADT) Received: from curry.tmsl.demon.co.uk (tmsl-adsl.demon.co.uk [80.177.114.181]) by svr1.postgresql.org (Postfix) with ESMTP id C36AFD1C4DB for ; Fri, 8 Aug 2003 08:29:15 -0300 (ADT) Received: from bacon.tmsl.demon.co.uk (bacon.tmsl.demon.co.uk [192.168.7.102]) by curry.tmsl.demon.co.uk (8.11.6/8.11.6) with ESMTP id h78BS1926280; Fri, 8 Aug 2003 12:28:02 +0100 Date: Fri, 8 Aug 2003 12:28:00 +0100 From: Paul Thomas To: mixo Cc: "pgsql-performance @ postgresql . org" Subject: Re: Perfomance Tuning Message-ID: <20030808122800.A10464@bacon> References: <3F337B39.5030904@coza.net.za> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <3F337B39.5030904@coza.net.za>; from mixo@coza.net.za on Fri, Aug 08, 2003 at 11:28:09 +0100 X-Mailer: Balsa 1.2.3 Lines: 30 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/151 X-Sequence-Number: 2968 On 08/08/2003 11:28 mixo wrote: > 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. It doesn't sound like a particlarly heavy loading to me. I'd start off with something like shared_buffers = 2000 sort_mem = 1024 max_coonections = 100 and see how it performs under normal business loading. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+