From: Szymon Kosok <szymon@mwg.pl>
To: pgsql-performance@postgresql.org
Subject: ~400 TPS - good or bad?
Date: Sat, 12 Jun 2010 14:03:10 +0200
Message-ID: <AANLkTilrm79Bu5PE2xd7K9nvTnE-Rq6Fy5a6XaHVfVWr@mail.gmail.com> (raw)
Hello,
We are trying to optimize our box for Postgresql. We have i7, 8GB of
ram, 2xSATA RAID1 (software) running on XFS filesystem. We are running
Postgresql and memcached on that box. Without any optimizations (just
edited PG config) we got 50 TPS with pg_bench default run (1 client /
10 transactions), then we've added to /home partition (where PGDATA
is) logbuf=8 and nobarrier. With that fs setup TPS in default test is
unstable, 150-300 TPS. So we've tested with -c 100 -t 10 and got
stable ~400 TPS. Question is - is it decent result or we can get much
more from Postgres on that box setup? If yes, what we need to do? We
are running Gentoo.
Here's our config: http://paste.pocoo.org/show/224393/
PS. pgbench scale is set to "1".
--
Greetings,
Szymon
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: szymon@mwg.pl
Subject: Re: ~400 TPS - good or bad?
In-Reply-To: <AANLkTilrm79Bu5PE2xd7K9nvTnE-Rq6Fy5a6XaHVfVWr@mail.gmail.com>
* 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