X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 71C99D1B181 for ; Mon, 2 Aug 2004 19:47:20 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60036-02 for ; Mon, 2 Aug 2004 22:47:20 +0000 (GMT) Received: from mail.coretech.co.nz (coretech.co.nz [202.36.204.41]) by svr1.postgresql.org (Postfix) with ESMTP id 155E5D1B17B for ; Mon, 2 Aug 2004 19:47:16 -0300 (ADT) Received: (qmail 30963 invoked from network); 2 Aug 2004 22:47:18 -0000 Received: from localhost (127.0.0.1) by 0 with SMTP; 2 Aug 2004 22:47:18 -0000 Received: from 203.167.203.141 ([203.167.203.141]) by mail.coretech.co.nz (Horde) with HTTP for ; Tue, 3 Aug 2004 10:47:18 +1200 Message-ID: <1091486838.923c2b71c3ae6@mail.coretech.co.nz> Date: Tue, 3 Aug 2004 10:47:18 +1200 From: markir@coretech.co.nz To: Stephane Tessier Cc: 'Scott Marlowe' , pgsql-performance@postgresql.org Subject: Re: my boss want to migrate to ORACLE References: <004b01c478d6$47f46530$4e00020a@develavoie> In-Reply-To: <004b01c478d6$47f46530$4e00020a@develavoie> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) 4.0-cvs X-Originating-IP: Withheld X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200408/24 X-Sequence-Number: 7660 It may be worth pricing up expansion options e.g. 256M or more. The other path to consider is changing RAID5 -> RAID10 if your card supports it. However, I would recommend reducing that shared_buffers setting and doing your performance measurements *again* - before changing anything else. This is because you want to ensure that all your io hammering is not just because you are making the machine swap (by giving postgres too much memory as Scott mentioned)! Quoting Stephane Tessier : > I checked and we have a 128 megs battery backed cache on the raid > controller...