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 37ACFD1B1BE for ; Fri, 30 Jul 2004 14:56:40 -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 51004-05 for ; Fri, 30 Jul 2004 17:56:35 +0000 (GMT) Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by svr1.postgresql.org (Postfix) with ESMTP id B91C1D1B16B for ; Fri, 30 Jul 2004 14:56:33 -0300 (ADT) Received: from 64.sub-166-155-3.myvzw.com ([166.155.3.64]) by outbound.mailhop.org with asmtp (TLSv1:AES256-SHA:256) (Exim 4.20) id 1BqbcL-000N8q-6g; Fri, 30 Jul 2004 13:56:30 -0400 Message-ID: <410A8BC0.3070106@zeut.net> Date: Fri, 30 Jul 2004 13:56:16 -0400 From: "Matthew T. O'Connor" User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stephane Tessier Cc: markir@coretech.co.nz, pgsql-performance@postgresql.org Subject: Re: my boss want to migrate to ORACLE References: <001f01c4763c$fcef40f0$4e00020a@develavoie> In-Reply-To: <001f01c4763c$fcef40f0$4e00020a@develavoie> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Mail-Handler: MailHop Outbound by DynDNS.org X-Originating-IP: 166.155.3.64 X-Report-Abuse-To: abuse@dyndns.org (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: zeut X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/241 X-Sequence-Number: 7632 Stephane Tessier 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) >iowait is very high 98% --> look like postgresql wait for io access >raid5 -->raid0 if i'm right raid5 use 4 writes(parity,data, etc) for each >write on disk >use more transactions (we have a lot of insert/update without transaction). >cpu look like not running very hard > >*php is not running on the same machine >*redhat enterprise 3.0 ES >*the version of postgresql is 7.3.4(using RHDB from redhat) >*pg_autovacuum running at 12 and 24 hour each day > > What do you mean by "pg_autovacuum running at 12 and 24 hour each day"?