From: lst_hoe02@kwsoft.de
To: pgsql-admin@postgresql.org
Subject: Re: Maximum insert per second
Date: Sun, 17 Jul 2011 12:40:28 +0200
Message-ID: <20110717124028.29525na3zeurzyg4@webmail.kwsoft.de> (raw)
In-Reply-To: <CAOR=d=0o0eC-9BH820_WDeWctmm0F3-m2mhbx0P6CdPSq+jAFg@mail.gmail.com>
References: <CANqFkjHxz7dwBgQhzUgO2SABDBs_Nn+DzVEq4UsGhuMtURXfqA@mail.gmail.com>
<4E1C0C9C020000250003F225@gw.wicourts.gov>
<20110715100926.91335pd1uvzhoz8c@webmail.kwsoft.de>
<CAOR=d=2m_nKyzn8_S1iX7UnMgyCUGkS6a2XHPmVpbTPdZa96+A@mail.gmail.com>
<CAOR=d=0o0eC-9BH820_WDeWctmm0F3-m2mhbx0P6CdPSq+jAFg@mail.gmail.com>
Zitat von Scott Marlowe <scott.marlowe@gmail.com>:
> 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
>
Thanks, very impressive.
Regards
Andreas
Attachments:
smime.p7s (application/pkcs7-signature, 5.9K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lst_hoe02@kwsoft.de
Subject: Re: Maximum insert per second
In-Reply-To: <20110717124028.29525na3zeurzyg4@webmail.kwsoft.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox