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 still
On Sun, Mar 10, 2013 at 7:18 PM, Jon Nelson 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. Why are these tps so hi
On Sun, Mar 10, 2013 at 10:46 AM, Greg Smith wrote:
> On 3/5/13 10:00 PM, Jon Nelson wrote:
>>
>> On Tue, Mar 5, 2013 at 1:35 PM, Jon Nelson
>> 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
>>
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 comments/p
On 3/5/13 10:00 PM, Jon Nelson wrote:
On Tue, Mar 5, 2013 at 1:35 PM, Jon Nelson 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 400)
Some followup:
The
