On 3/5/13 10:00 PM, Jon Nelson wrote:
On Tue, Mar 5, 2013 at 1:35 PM, Jon Nelson jnelson+pg...@jamponi.net wrote:
pgbench -h BLAH -c 32 -M prepared -t 10 -S
I get 95,000 to 100,000 tps.
pgbench -h BLAH -c 32 -M prepared -t 10
seems to hover around 6,200 tps (size 100) to 13,700 (size
On 3/1/13 6:43 AM, Niels Kristian Schjødt wrote:
Hi, I'm going to setup a new server for my postgresql database, and I am
considering one of these:
http://www.hetzner.de/hosting/produkte_rootserver/poweredge-r720 with four SAS
drives in a RAID 10 array. Has any of you any particular
On Sun, Mar 10, 2013 at 10:46 AM, Greg Smith g...@2ndquadrant.com wrote:
On 3/5/13 10:00 PM, Jon Nelson wrote:
On Tue, Mar 5, 2013 at 1:35 PM, Jon Nelson jnelson+pg...@jamponi.net
wrote:
pgbench -h BLAH -c 32 -M prepared -t 10 -S
I get 95,000 to 100,000 tps.
pgbench -h BLAH -c 32 -M
On Sun, Mar 10, 2013 at 7:18 PM, Jon Nelson jnelson+pg...@jamponi.net wrote:
It seems as though you say the write numbers are not believable,
suggesting a value of 7,500 (roughly 1/4 what I'm getting). If I run
the read test for 30 seconds I get - highly variable - between 300K
and 400K tps.
On 3/10/13 9:18 PM, Jon Nelson wrote:
The following is with ext4, nobarrier, and noatime. As noted in the
original post, I have done a fair bit of system tuning. I have the
dirty_bytes and dirty_background_bytes set to 3GB and 2GB,
respectively.
That's good, but be aware those values are