pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Mair <list@1006.org>
To: pgsql-performance@postgresql.org
Subject: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
Date: Tue, 15 Mar 2005 14:44:07 +0100
Message-ID: <1110894247.4441.49.camel@dell> (raw)

Hello,

just recently I held a short course on PG.

One course attendant, Robert Dollinger, got 
interested in benchmarking single inserts (since
he currently maintains an application that does
exactly that on Firebird and speed is an issue
there).

He came up with a table that I think is interesting
for other people so I asked permission to publish
it on this list.

Here it is:
http://1006.org/pg/postgresql_firebird_win_linux.pdf

Note: some german words are there, I can't change
the pdf, so here's a short explanation:

He tested the speed of 4000 inserts through a Delphi
application with zeos components.

the 3 parameters are:

* transaction
  - single: all 4000 inserts inside 1 transaction
  - multi: 4000 inserts with 4000 commits

* fsync (for PG) or forced writes (for FB)
  - true/false

* "Verbindung" = connection
  - local
  - LAN
  - wireless

  notes: the server ran either on a windows desktop
  machine or a linux laptop; the client allways ran
  on the windows desktop

Timings are in msec, note that you cannot directly
compare Windows and Linux Performance, since machines
were different.

You can, however, compare PG to Firebird, and you
can see the effect of the 3 varied parametert.

One thing that stands out is how terribly
bad Windows performed with many small single
transactions and fsync=true.

Appearantly fsync on Windows is a very costly
operation.

Another (good) thing is that PG beats FB on all
other tests :-)


Bye, Chris.








view thread (4+ messages)  latest in thread

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

 · 

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
  Subject: Re: interesting benchmarks PG/Firebird Linux/Windows fsync/nofsync
  In-Reply-To: <1110894247.4441.49.camel@dell>

* 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