Re: Maximum insert per second

Zitat von Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:

> On Fri, Jul 15, 2011 at 3:39 AM, Scott Marlowe
> <scott(dot)marlowe(at)gmail(dot)com> wrote:
>>
>> System: SuperMicro H8QG6
>> 4xAMD Opteron(tm) Processor 6168
>> Total 48 cores
>> 128G RAM
>> Areca 1680 w 512M battery backed cache
>> 32 15k SAS 147Gig drives
>>
>> pgbench -i -s 100
>> pgbench -c 48 -t 10000
>> tps = 7777.626762 (including connections establishing)
>> tps = 7808.976047 (excluding connections establishing)
>>
>> If I run them for much longer, it'll drop down a bit and average about
>> 4 to 5k sustained tps.
>
> Correction, I just ran a much longer test that would have involved at
> least 1 checkpoint and was still getting ~7800tps on this machine.
>
> OS is Ubuntu 10.04. Only non-stock settings are:
>
> sysctl.conf:
> vm.zone_reclaim_mode = 0
> kernel.shmmax = 33554432000
> kernel.shmall = 209715200
> kernel.shmmni = 4096
>
> /etc/rc.local:
> swapoff -a
>

Thanks, very impressive.

Regards

Andreas