Re: wal_buffer tests in

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

> 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?

No, take a look at the graph.   It looks like we got the maximum effect 
from a wal_buffers somewhere between 64 and 256.   On the DBT2 runs, any 
variation less than 5% is just noise.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Some new list.c primitives
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [Testperf-general] dbt2 & opteron performance