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 21D76D1B17B for ; Mon, 2 Aug 2004 18:18:47 -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 21601-09 for ; Mon, 2 Aug 2004 21:18:43 +0000 (GMT) Received: from asdc003.abovesecurite.lan (unknown [206.162.148.235]) by svr1.postgresql.org (Postfix) with ESMTP id 2E77BD1B19A for ; Mon, 2 Aug 2004 18:18:37 -0300 (ADT) Received: from develavoie ([206.162.148.230]) by asdc003.abovesecurite.lan over TLS secured channel with Microsoft SMTPSVC(6.0.3790.0); Mon, 2 Aug 2004 17:23:45 -0400 From: "Stephane Tessier" To: "'Scott Marlowe'" Cc: , Subject: Re: my boss want to migrate to ORACLE Date: Mon, 2 Aug 2004 17:18:38 -0400 Message-ID: <004b01c478d6$47f46530$4e00020a@develavoie> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <1091200491.27159.56.camel@localhost.localdomain> Importance: Normal x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1409 X-OriginalArrivalTime: 02 Aug 2004 21:23:45.0156 (UTC) FILETIME=[FDEA9440:01C478D6] 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: 200408/19 X-Sequence-Number: 7655 I checked and we have a 128 megs battery backed cache on the raid controller... -----Original Message----- From: Scott Marlowe [mailto:smarlowe@qwest.net] Sent: 30 juillet, 2004 11:15 To: Stephane Tessier Cc: markir@coretech.co.nz; pgsql-performance@postgresql.org Subject: Re: [PERFORM] my boss want to migrate to ORACLE On Fri, 2004-07-30 at 07:56, 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 Just get battery backed cache on your RAID controller. RAID0 is way too unreliable for a production environment. One disk dies and all your data is just gone. > 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 > > > > -----Original Message----- > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of > markir@coretech.co.nz > Sent: 29 juillet, 2004 23:00 > To: Stephane Tessier > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] my boss want to migrate to ORACLE > > > A furthur thought or two: > > - you are *sure* that it is Postgres that is slow? (could be Php...or your > machine could be out of some resource - see next 2 points) > - is your machine running out of cpu or memory? > - is your machine seeing huge io transfers or long io waits? > - are you running Php on this machine as well as Postgres? > - what os (and what release) are you running? (guessing Linux but...) > > As an aside, they always say this but: Postgres 7.4 generally performs > better > than 7.3...so an upgrade could be worth it - *after* you have > solved/identified > the other issues. > > best wishes > > Mark > > Quoting Stephane Tessier : > > > Hi everyone, > > > > somebody can help me??????? my boss want to migrate to > > ORACLE................ > > > > we have a BIG problem of performance,it's slow.... > > we use postgres 7.3 for php security application with approximately 4 > > millions of insertion by day and 4 millions of delete and update > > and archive db with 40 millions of archived stuff... > > > > we have 10 databases for our clients and a centralized database for the > > general stuff. > > > > database specs: > > > > double XEON 2.4 on DELL PowerEdge2650 > > 2 gigs of RAM > > 5 SCSI Drive RAID 5 15rpm > > > > tasks: > > > > 4 millions of transactions by day > > 160 open connection 24 hours by day 7 days by week > > pg_autovacuum running 24/7 > > reindex on midnight > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >