Re: More benchmarking of wal_buffers

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: More benchmarking of wal_buffers
Дата
Msg-id GNELIHDDFBOCMGBFGEFOCEIPCFAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: More benchmarking of wal_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: More benchmarking of wal_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> I don't think this is based on a useful test for wal_buffers.  The
> wal_buffers setting only has to be large enough for the maximum amount
> of WAL log data that your system emits between commits, because a commit
> (from anyone) is going to flush the WAL data to disk (for everyone).
> So a benchmark based on short transactions is just not going to show
> any benefit to increasing the setting.

Here's a question then - what is the _drawback_ to having 1024 wal_buffers
as opposed to 8?

Chris


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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: More benchmarking of wal_buffers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: More benchmarking of wal_buffers