Re: v7.1b4 bad performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: v7.1b4 bad performance
Дата
Msg-id 23508.982374576@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: v7.1b4 bad performance  ("Schmidt, Peter" <peter.schmidt@prismedia.com>)
Список pgsql-admin
BTW, what -B setting were you running the postmaster with?  While poking
at this, I was reminded that having adequate buffer space really makes
a considerable difference ... especially under WAL, where it's not
necessary to flush dirty buffers to disk at the end of each transaction.
The default -B 64 is certainly too small to get reasonable performance.
I got roughly twice the tps reading (pgbench -t 1000, with -F) at -B 1024.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: v7.1b4 bad performance
Следующее
От: "Schmidt, Peter"
Дата:
Сообщение: RE: v7.1b4 bad performance