pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresSQL vs. Firebird
2+ messages / 2 participants
[nested] [flat]
* PostgresSQL vs. Firebird
@ 2005-07-14 07:19 Relaxin <me@yourhouse.com>
2005-07-15 09:17 ` Re: PostgresSQL vs. Firebird Chris Mair <list@1006.org>
0 siblings, 1 reply; 2+ messages in thread
From: Relaxin @ 2005-07-14 07:19 UTC (permalink / raw)
To: pgsql-performance
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?
I've just recently started reading the Firebird NG and a poster over there
has brought up some serious issues with Firebird, but they seem to not take
the issues seriously.
I first wanted to go with Firebird for 2 reasons...
Very easy to configure and very easy to install.
I assumed that the database worked ok, but I'm not so sure now.
So, I've decided to give PG a try...I've downloaded it, but haven't
installed it yet.
So any provable information that you can provide as to why/how PG is
better/faster/easier/reliable than Firebird would be greatly appreciated.
Thanks
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgresSQL vs. Firebird
2005-07-14 07:19 PostgresSQL vs. Firebird Relaxin <me@yourhouse.com>
@ 2005-07-15 09:17 ` Chris Mair <list@1006.org>
0 siblings, 0 replies; 2+ messages in thread
From: Chris Mair @ 2005-07-15 09:17 UTC (permalink / raw)
To: Relaxin <me@yourhouse.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-15 09:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-14 07:19 PostgresSQL vs. Firebird Relaxin <me@yourhouse.com>
2005-07-15 09:17 ` Chris Mair <list@1006.org>
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