X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CFB53D1DA9B for ; Thu, 15 Jan 2004 14:17:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 70443-01 for ; Thu, 15 Jan 2004 10:17:26 -0400 (AST) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id 62AACD1DA6C for ; Thu, 15 Jan 2004 10:17:22 -0400 (AST) Received: from solent (82-68-95-1.dsl.in-addr.zen.co.uk [82.68.95.1]) by bayswater1.ymogen.net (Postfix) with ESMTP id CAE319AD07; Thu, 15 Jan 2004 14:17:24 +0000 (GMT) From: "Matt Clark" To: "Syd" <569170@aliencamel.com>, Subject: Re: insert speed - Mac OSX vs Redhat Date: Thu, 15 Jan 2004 14:17:24 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/152 X-Sequence-Number: 5327 > On a variety of hardware with Redhat, and versions of postgres, we're > not getting much better than 50 inserts per second. This is prior to > moving WAL to another disk, and fsync is on. > > However, with postgres 7.4 on Mac OSX 10.2.3, we're getting an amazing > 500 inserts per second. > > We can only put this down to the OS. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ You haven't really produced much evidence to support that statement. Given that the differences in performance between Postgres running on *BSD and Linux on Intel hardware are not large at all, it seems to be almost certainly false in fact. It may of course be due to some settings of the different OSes, but not the OSes themselves. It would help if you gave a straight PG7.4 comparison with hardware specs as well, and config file differences if any. One thought: assuming the Apple has IDE disks, then the disks probably have write caching turned on, which is good for speed, but not crash-safe. matt