pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ivan Voras <ivoras@geri.cc.fer.hr>
To: pgsql-performance@postgresql.org
Subject: Benchmarking PostgreSQL?
Date: Sun, 25 Jan 2004 02:01:53 +0100
Message-ID: <40131581.7000300@geri.cc.fer.hr> (raw)

I'm conducting some benchmarking (mostly for fun and learning), and one 
part of it is benchmarking PostgreSQL (7.4.1, on FreeBSD 4.9 and 5.2). 
I'm using pgbench from the contrib directory, but I'm puzzled by the 
results. I have little experience in benchmarking, but I don't think I 
should be getting the scattered results I have.

- the computer is P3 @ 933MHz, 1Gb RAM
- I'm running pgbench with 35 clients and 50 transactions/client
- benchmark results are differentiating by about +/- 6 TPS. The results 
are between 32 TPS and 44 TPS
- the results seem to be getting worse over time then suddenly jumping 
to the maximum (saw-tooth like). Sometime there is even (very noticable 
as a pattern!) indication of more-or-less regular alteration between the 
minimum and maximum values (e.g. first measurement yields 32, second 
yields 44, third again 32 or 31, etc...)
- running vacuumdb -z -f on the database does not influence the results 
in predictable ways
- waiting (sleeping) between pgbench runs (either regular or random) 
does not influence it in predictable ways
- the same patterns appear between operating systems (FreeBSD 4.9 and 
5.2) and reinstalls of it (the numbers are ofcourse somewhat different)

postgresql.conf contains only these active lines:
  max_connections = 40
  shared_buffers = 10000
  sort_mem = 8192
  vacuum_mem = 32768

I've used these settings as they are expected to be used on a regular 
work load when the server goes into production. I've upped vacuum_mem as 
it seems to shorten vacuum times dramaticaly (I assume the memory is 
allocated when needed as the postgresql process is only 88MB in size 
(80Mb shared buffers)).

What I'm really asking here is: are these results normal? If not, can 
they be improved, or is there a better off-the-shelf PostgreSQL 
benchmark tool?





view thread (3+ messages)  latest in thread

Message-ID: <40131581.7000300@geri.cc.fer.hr>
Permalink:  ../40131581.7000300@geri.cc.fer.hr/
Also on:    postgresql.org/message-id/40131581.7000300@geri.cc.fer.hr

 · 

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: ivoras@geri.cc.fer.hr
  Subject: Re: Benchmarking PostgreSQL?
  In-Reply-To: <40131581.7000300@geri.cc.fer.hr>

* 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