Postgres Pro
Downloads
Home   >   mailing lists

Re: ~400 TPS - good or bad? - Mailing list pgsql-performance

From Szymon Kosok
Subject Re: ~400 TPS - good or bad?
Date
Msg-id AANLkTileyxtnjSV0S-gyfhetrQZrOuG5FyHGC8NKY40k@mail.gmail.com
Whole thread Raw
In response to ~400 TPS - good or bad?  (Szymon Kosok <szymon@mwg.pl>)
Responses Re: ~400 TPS - good or bad?  (Merlin Moncure <mmoncure@gmail.com>)
Re: ~400 TPS - good or bad?  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
Tree view 
2010/6/12 Szymon Kosok <szymon@mwg.pl>:
> PS. pgbench scale is set to "1".

I've found in mailing list archive that scale = 1 is not good idea. So
we have ran pgbench -s 200 (our database is ~3 GB) -c 10 -t 3000 and
get about ~600 TPS. Good or bad?

--
Greetings,
Szymon

pgsql-performance by date:

Previous
From: Szymon Kosok
Date:
Subject: ~400 TPS - good or bad?
Next
From: Merlin Moncure
Date:
Subject: Re: ~400 TPS - good or bad?