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 по дате отправления: