X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ECEB59FA3AD for ; Fri, 19 May 2006 07:24:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34937-05 for ; Fri, 19 May 2006 07:24:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.206]) by postgresql.org (Postfix) with ESMTP id 47D659F9F8F for ; Fri, 19 May 2006 07:24:36 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id h31so166438wxd for ; Fri, 19 May 2006 03:24:35 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=py+gkwtJdzr1rj+nlNfLMZkQ+j0V5yMusuoUQWGdunUxorjsUXLk59QQLWIkqxTJHyp8vBG/5iFgqLHKQlxOhQ71lHYL5e1xpljOrsDqphfo7UFIlfhwnc3LHsfny/bdl9Ba/a07R13FsBVQMvT8JhYVDPlQ5K9vcPxktxxbDBs= Received: by 10.70.109.19 with SMTP id h19mr1353130wxc; Fri, 19 May 2006 03:24:35 -0700 (PDT) Received: by 10.70.74.19 with HTTP; Fri, 19 May 2006 03:24:35 -0700 (PDT) Message-ID: Date: Fri, 19 May 2006 12:24:35 +0200 From: "Olivier Andreotti" To: "Tom Lane" Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2 Cc: "Mikael Carneholm" , jean-paul@argudo.org, pgsql-performance@postgresql.org In-Reply-To: <13688.1147963700@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <7F10D26ECFA1FB458B89C5B4B0D72C2B459FFB@sesrv12.wirelesscar.com> <13688.1147963700@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/401 X-Sequence-Number: 19188 Hello everybody ! Thanks for all the advices, iI will try all theses new values, and i'll post my final values on this thread. About the benchmark and the results, i dont know if can publish values about Oracle performance ? For MySQL and PostgreSQL, i think there is no problems. Just a last question about the pg_xlog : i understand that the directory must be moved but i have just 3 disks for the database : disk 1 and 2 for the data, disk 3 for the indexes, where can i put the pg_xlog ? OA.