~400 TPS - good or bad?

From: Szymon Kosok <szymon(at)mwg(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: ~400 TPS - good or bad?
Date: 2010-06-12 12:03:10
Message-ID: AANLkTilrm79Bu5PE2xd7K9nvTnE-Rq6Fy5a6XaHVfVWr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Kosok 2010-06-12 12:37:21 Re: ~400 TPS - good or bad?
Previous Message David Jarvis 2010-06-11 20:38:07 Re: Analysis Function