Re: [PERFORM] More benchmarking of wal_buffers

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [PERFORM] More benchmarking of wal_buffers
Дата
Msg-id GNELIHDDFBOCMGBFGEFOGEIPCFAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: More benchmarking of wal_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PERFORM] More benchmarking of wal_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > Here's a question then - what is the _drawback_ to having 1024
> wal_buffers
> > as opposed to 8?
>
> Waste of RAM?  You'd be better off leaving that 8 meg available for use
> as general-purpose buffers ...

What I mean is say you have an enterprise server doing heaps of transactions
with lots of work.  If you have scads of RAM, could you just shove up
wal_buffers really high and assume it will improve performance?

Chris


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: location of the configuration files
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: Changing the default configuration (was Re: [pgsql-advocacy]