X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 43C559DCB93 for ; Thu, 22 Dec 2005 03:10:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29358-01 for ; Thu, 22 Dec 2005 03:10:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id C2FF99DCAB5 for ; Thu, 22 Dec 2005 03:10:50 -0400 (AST) Received: from 172.16.1.148 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Thu, 22 Dec 2005 02:10:46 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 22 Dec 2005 02:10:45 -0500 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Thu, 22 Dec 2005 07:10:44 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Wed, 21 Dec 2005 23:10:43 -0800 Subject: Re: MySQL is faster than PgSQL but a large margin in From: "Luke Lonergan" To: "Madison Kelly" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] MySQL is faster than PgSQL but a large margin in Thread-Index: AcYGxcIo+KPvYc+RScyAAU8L5+Qj+gAARBBr In-Reply-To: <43AA4F97.40201@alteeve.com> MIME-Version: 1.0 X-OriginalArrivalTime: 22 Dec 2005 07:10:45.0304 (UTC) FILETIME=[D3C82B80:01C606C6] X-WSS-ID: 6FB48EFF3301884373-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.295 required=5 tests=[AWL=0.042, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.295 X-Spam-Level: * X-Archive-Number: 200512/564 X-Sequence-Number: 16385 Madison, On 12/21/05 11:02 PM, "Madison Kelly" wrote: > Currently 7.4 (what comes with Debian Sarge). I have run my program on > 8.0 but not since I have added MySQL support. I should run the tests on > the newer versions of both DBs (using v4.1 for MySQL which is also > mature at this point). Yes, this is *definitely* your problem. Upgrade to Postgres 8.1.1 or Bizgres 0_8_1 and your COPY speed could double without even changing fsync (depending on your disk speed). We typically get 12-14MB/s from Bizgres on Opteron CPUs and disk subsystems that can write at least 60MB/s. This means you can load 100GB in 2 hours. Note that indexes will also slow down loading. - Luke