Re: wal_buffer tests in

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: wal_buffer tests in
Дата
Msg-id 87oe8n881i.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на wal_buffer tests in  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: wal_buffer tests in  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:

> Folks,
> 
> I ran a wal_buffer test series.   It appears that increasing the 
> wal_buffers is indeed very important for OLTP applications, potentially 
> resulting in as much as a 15% average increase in transaction processing.  
> What's interesting is that this is not just true for 8.1, it's true for 
> 8.0.3 as well.   

You have wal_buffer set to 2048? That's pretty radical compared to the default
of just 5. Your tests shows you had to go to this large a value to see the
maximum effect?

-- 
greg



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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: snapshot build broken ...
Следующее
От: "Kevin McArthur"
Дата:
Сообщение: Re: RESULT_OID Bug