Re: Maximum insert per second

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