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 043B952A94 for ; Fri, 15 Jul 2005 06:17:19 -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 93100-02 for ; Fri, 15 Jul 2005 09:17:13 +0000 (GMT) Received: from my.endian.it (unknown [62.146.87.34]) by svr1.postgresql.org (Postfix) with ESMTP id BD83752A80 for ; Fri, 15 Jul 2005 06:17:11 -0300 (ADT) Received: from dell.1006.org (host232-14.pool80183.interbusiness.it [80.183.14.232]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id j6F985M13202; Fri, 15 Jul 2005 11:08:05 +0200 Subject: Re: PostgresSQL vs. Firebird From: Chris Mair To: Relaxin Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Fri, 15 Jul 2005 11:17:11 +0200 Message-Id: <1121419031.2721.9.camel@dell.1006.org> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 (2.2.2-5) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/214 X-Sequence-Number: 13455 On Thu, 2005-07-14 at 00:19 -0700, Relaxin wrote: > Before I ask, I don't want to start a war. > > Can someone here give me an honest opinion of how PostgresSQL (PG) is better > than Firebird on Windows? A colleague of mine has made some benchmarks using those two: http://www.1006.org/pg/postgresql_firebird_win_linux.pdf He benchmarked inserts done through *his* own Delphi code varying a few parameters. The servers run on Windows in all tests. The clients were on Windows or Linux. The summary is that PG beats FB performance-wise in all tests except when you do many small transactions (autocommit on) with fsync on. Bye, Chris.