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 394A4D1B1D2 for ; Sat, 31 Jul 2004 01:13:30 -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 55067-08 for ; Sat, 31 Jul 2004 04:13:25 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id 7EB25D1B1B9 for ; Sat, 31 Jul 2004 01:13:23 -0300 (ADT) Received: (qmail 17597 invoked by uid 0); 31 Jul 2004 04:13:22 -0000 Received: from mpls-pop-12.inet.qwest.net (63.231.195.12) by mpls-qmqp-04.inet.qwest.net with QMQP; 31 Jul 2004 04:13:22 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-12.inet.qwest.net with SMTP; 31 Jul 2004 04:13:22 -0000 Date: Fri, 30 Jul 2004 22:14:41 -0600 Message-Id: <1091247281.27159.726.camel@localhost.localdomain> From: "Scott Marlowe" To: "Christopher Browne" Cc: pgsql-performance@postgresql.org Subject: Re: my boss want to migrate to ORACLE In-Reply-To: References: <1091156393.39517b44365bc@mail.coretech.co.nz> <001f01c4763c$fcef40f0$4e00020a@develavoie> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/245 X-Sequence-Number: 7636 On Fri, 2004-07-30 at 19:22, Christopher Browne wrote: > After a long battle with technology, stephane.tessier@abovesecurity.com ("Stephane Tessier"), an earthling, wrote: > > I think with your help guys I'll do it! > > > > I'm working on it! > > > > I'll work on theses issues: > > > > we have space for more ram(we use 2 gigs on possibility of 3 gigs) > > That _may_ help; not completely clear. > > > iowait is very high 98% --> look like postgresql wait for io access > > In that case, if you haven't got a RAID controller with battery backed > cache, then that should buy you a BIG boost in performance. Maybe > $1500 USD; that could be money FABULOUSLY well spent. > > > raid5 -->raid0 if i'm right raid5 use 4 writes(parity,data, etc) for each > > write on disk > > I try to avoid talking about RAID levels, and leave them to others > :-). FYI, in a previous post on this topic, the original poster put up a top output that showed the machine using 2 gigs of swap with 150 Meg for kernel cache, and all the memory being used by a few postgresql processes. The machine was simply configured to give WAY too much memory to shared buffers and sort mem and this was likely causing the big slowdown. Adding a battery backed caching RAID controller and properly configuring postgresql.conf should get him into the realm of reasonable performance.