Re: cvs head? initdb?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: cvs head? initdb?
Дата
Msg-id 3FB51F39.1030902@Yahoo.com
обсуждение исходный текст
Ответ на Re: cvs head? initdb?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: cvs head? initdb?
Список pgsql-hackers
Bruce Momjian wrote:

> Jan Wieck wrote:
>> >> Yeah, there was a problem with *extreme* sharing ... the code tried to 
>> >> use the same buffer for multiple disk blocks at the same time, and 
>> >> somehow the backends did not agree on the correct content. But it's 
>> >> fixed and back in. You can see ARC working by setting
>> >> 
>> >>      buffer_strategy_status_interval = 10 # seconds
> 
> The above line is the one I was asking about?  Does that just control
> debug output interval?  If so, it should be named more appropriately.

Yes, all it controls is the DEBUG1 output eveny N seconds. What is 
inappropriate about it? It is exactly that, it shows the sizes and 
recent hit rates for the 4 different CDB queues of the strategy. Have a 
better one?

The output is not really of any use yet. The background writer though 
will add a third line to this output, the number of clean buffers in 
front of the T1 and T2 queues. That will be the #1 tool for adjusting 
the background writer parameters so that it keeps the cache clean enough 
that backends don't need to write, and dirty enough that high frequently 
used blocks don't get written too often.

> 
>> >> 
>> >> and starting postmaster with -d1
>> > 
>> > It is not on by default?
>> > 
>> 
>> Sure not. Why would someone turn on debug messages by default?
>> 
>> Or did you mean ARC itself? Since it replaced the old LRU code, it is 
>> the only choice you have now. Which sort of raises the question if we 
>> would want to have multiple choices, like a config option
>> 
>> buffer_replacement_strategy = lru|lru2|arc
> 
> No, I don't see much value to this and would encourage people to play
> with something that probably is is of little value.

Me neither, just wanted to have asked.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: INSERT extremely slow with large data sets
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Need help.