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 13A06D1C9AB for ; Fri, 8 Aug 2003 10:51:11 +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 15890-03 for ; Fri, 8 Aug 2003 07:49:46 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 33867D1C990 for ; Fri, 8 Aug 2003 07:50:59 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h78Aq6Yb010719 for ; Fri, 8 Aug 2003 16:22:06 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h78Aq57f010705; Fri, 8 Aug 2003 16:22:05 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org, mixo Date: Fri, 08 Aug 2003 16:22:52 +0530 MIME-Version: 1.0 Subject: Re: Perfomance Tuning Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F33CE5C.23372.A81DD87@localhost> In-reply-to: <3F337B39.5030904@coza.net.za> 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: 200308/150 X-Sequence-Number: 2967 On 8 Aug 2003 at 12: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. You can look at http://www.varlena.com/GeneralBits/Tidbits/perf.html to start with, although that would not take careof anything specifics to BLOB. I would suggest some pilot benchmark about how system performs after initial tuning. We could discuss this in detail after you have a set of initial benchmark. HTH Bye Shridhar -- wolf, n.: A man who knows all the ankles.