Re: Maximum insert per second

Поиск
Список
Период
Сортировка
От lst_hoe02@kwsoft.de
Тема Re: Maximum insert per second
Дата
Msg-id 20110717124028.29525na3zeurzyg4@webmail.kwsoft.de
обсуждение исходный текст
Ответ на Re: Maximum insert per second  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
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


Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Cédric Villemain
Дата:
Сообщение: Re: 9.0.4 Data corruption issue
Следующее
От: Ken Caruso
Дата:
Сообщение: Re: 9.0.4 Data corruption issue