Re: Maximum insert per second

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Maximum insert per second
Дата
Msg-id CAOR=d=0o0eC-9BH820_WDeWctmm0F3-m2mhbx0P6CdPSq+jAFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Maximum insert per second  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Maximum insert per second  (lst_hoe02@kwsoft.de)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Maximum insert per second
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Importing the dump file in postgresql-7.4.23