From: Mark Kirkwood <markir@paradise.net.nz>
To: pgsql-performance@postgresql.org
Subject: Solaris Performance (Again)
Date: Wed, 10 Dec 2003 18:56:38 +1300
Message-ID: <3FD6B596.8090803@paradise.net.nz> (raw)
This is a well-worn thread title - apologies, but these results seemed
interesting, and hopefully useful in the quest to get better performance
on Solaris:
I was curious to see if the rather uninspiring pgbench performance
obtained from a Sun 280R (see General: ATA Disks and RAID controllers
for database servers) could be improved if more time was spent
tuning.
With the help of a fellow workmate who is a bit of a Solaris guy, we
decided to have a go.
The major performance killer appeared to be mounting the filesystem with
the logging option. The next most significant seemed to be the choice of
sync_method for Pg - the default (open_datasync), which we initially
thought should be the best - appears noticeably slower than fdatasync.
We also tried changing some of the tuneable filesystem options using
tunefs - without any measurable effect.
Are Pg/Solaris folks running with logging on and sync_method default out
there ? - or have most of you been through this already ?
Pgbench Results (no. clients and transactions/s ) :
Setup 1: filesystem mounted with logging
No. tps
-----------
1 17
2 17
4 22
8 22
16 28
32 32
64 37
Setup 2: filesystem mounted without logging
No. tps
-----------
1 48
2 55
4 57
8 62
16 65
32 82
64 95
Setup 3 : filesystem mounted without logging, Pg sync_method = fdatasync
No. tps
-----------
1 89
2 94
4 95
8 93
16 99
32 115
64 122
Note : The Pgbench runs were conducted using -s 10 and -t 1000 -c 1->64,
2 - 3 runs of each setup were performed (averaged figures shown).
Mark
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: markir@paradise.net.nz
Subject: Re: Solaris Performance (Again)
In-Reply-To: <3FD6B596.8090803@paradise.net.nz>
* 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