pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Mair <list@1006.org>
To: Relaxin <me@yourhouse.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgresSQL vs. Firebird
Date: Fri, 15 Jul 2005 11:17:11 +0200
Message-ID: <1121419031.2721.9.camel@dell.1006.org> (raw)
In-Reply-To: <db53m4$520$1@news.hub.org>
References: <db53m4$520$1@news.hub.org>


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.







view thread (2+ messages)

Message-ID: <1121419031.2721.9.camel@dell.1006.org>
Permalink:  ../1121419031.2721.9.camel@dell.1006.org/
Also on:    postgresql.org/message-id/1121419031.2721.9.camel@dell.1006.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: list@1006.org, me@yourhouse.com
  Subject: Re: PostgresSQL vs. Firebird
  In-Reply-To: <1121419031.2721.9.camel@dell.1006.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox