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 7479D9DC81D for ; Thu, 22 Dec 2005 03:02:54 -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 27767-01 for ; Thu, 22 Dec 2005 03:02:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tomts36-srv.bellnexxia.net (tomts36.bellnexxia.net [209.226.175.93]) by postgresql.org (Postfix) with ESMTP id 7B6419DCBA1 for ; Thu, 22 Dec 2005 03:02:51 -0400 (AST) Received: from [192.168.1.99] ([64.229.117.133]) by tomts36-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20051222070251.CAIG5032.tomts36-srv.bellnexxia.net@[192.168.1.99]>; Thu, 22 Dec 2005 02:02:51 -0500 Message-ID: <43AA4F97.40201@alteeve.com> Date: Thu, 22 Dec 2005 02:02:47 -0500 From: Madison Kelly User-Agent: Debian Thunderbird 1.0.2 (X11/20051002) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Luke Lonergan CC: pgsql-performance@postgresql.org Subject: Re: MySQL is faster than PgSQL but a large margin in References: <3E37B936B592014B978C4415F90D662DE12012@MI8NYCMAIL06.Mi8.com> In-Reply-To: <3E37B936B592014B978C4415F90D662DE12012@MI8NYCMAIL06.Mi8.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [0] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.103 required=5 tests=[AWL=0.103] X-Spam-Score: 0.103 X-Spam-Level: X-Archive-Number: 200512/562 X-Sequence-Number: 16383 Luke Lonergan wrote: > What version of postgres? > > Copy has been substantially improved in bizgres and also in 8.1. > - Luke 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). As others mentioned though, so far the most likely explanation is the 'fsync' being enabled on PostgreSQL. Thanks for the reply! Madison -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Madison Kelly (Digimer) TLE-BU; The Linux Experience, Back Up Main Project Page: http://tle-bu.org Community Forum: http://forum.tle-bu.org -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-