Re: wal_buffers, redux

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: wal_buffers, redux
Дата
Msg-id CA+TgmoYKy8+bp4UoF3tS0hYpcfJ5q+pz7w6bEJu+GqiW=_g8Ng@mail.gmail.com
обсуждение исходный текст
Ответ на Re: wal_buffers, redux  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Tue, Mar 13, 2012 at 4:55 AM, Andres Freund <andres@anarazel.de> wrote:
> On Tuesday, March 13, 2012 03:26:34 AM Robert Haas wrote:
>> Meanwhile, here are some TPS graphs at 16MB and 32MB on the IBM POWER7
>> machine.  32 clients, 1800 seconds, scale factor 300, synchronous
>> commit off.
> That graph makes me cringe because its pretty representative of what I have
> seen in practise. Any chance we can get a ~10s average in there? I find it
> pretty hard to read more than "spikey".

I tried that but don't find it an improvement; however I'm attaching
an example for your consideration.

> Whats the filesystem + options on this?

ext4, default options.  Fedora 16, 3.2.6-3.fc16.ppc64.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: wal_buffers, redux
Следующее
От: Robert Haas
Дата:
Сообщение: Re: pg_upgrade and statistics