Re: PostgresSQL vs. Firebird

From: Chris Mair <list(at)1006(dot)org>
To: Relaxin <me(at)yourhouse(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgresSQL vs. Firebird
Date: 2005-07-15 09:17:11
Message-ID: 1121419031.2721.9.camel@dell.1006.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-07-15 14:16:16 Re: What's a lot of connections?
Previous Message Andreas Pflug 2005-07-15 08:19:08 Re: Profiler for PostgreSQL