Re: Maximum insert per second - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Maximum insert per second
Date
Msg-id CAOR=d=0o0eC-9BH820_WDeWctmm0F3-m2mhbx0P6CdPSq+jAFg@mail.gmail.com
Whole thread Raw
In response to Re: Maximum insert per second  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Maximum insert per second  (lst_hoe02@kwsoft.de)
List pgsql-admin
On Fri, Jul 15, 2011 at 3:39 AM, Scott Marlowe <scott.marlowe@gmail.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

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Maximum insert per second
Next
From: Scott Marlowe
Date:
Subject: Re: Importing the dump file in postgresql-7.4.23