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 37E66D1C4CA for ; Fri, 8 Aug 2003 10:41:42 +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 14995-03 for ; Fri, 8 Aug 2003 07:40:17 -0300 (ADT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id D7605D1C4B9 for ; Fri, 8 Aug 2003 07:41:30 -0300 (ADT) Received: from ip97.85.1311c-cud12k-02.ish.de ([62.143.85.97] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 19l4fo-00072q-00; Fri, 08 Aug 2003 12:40:40 +0200 Received: from pd95205c2.dip.t-dialin.net ([217.82.5.194] helo=shock) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 19l4fl-0004jF-00; Fri, 08 Aug 2003 12:40:37 +0200 Message-ID: <01ed01c35d99$73f08d70$0564a8c0@shock> From: "Bjoern Metzdorf" To: "mixo" , References: <3F337B39.5030904@coza.net.za> Subject: Re: Perfomance Tuning Date: Fri, 8 Aug 2003 12:40:13 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Scanner: exiscan *19l4fl-0004jF-00*0rJPZq5DIZE* http://duncanthrax.net/exiscan/ X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/149 X-Sequence-Number: 2966 > 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. For 15 users you won't need great tuning at all. Just make sure, that you have the right indizes on the tables and that you have good queries (query plan). About the 8Meg blobs, I don't know. Other people on this list may be able to give you hints here. Regards, Bjoern