Re: [PATCH] Don't bail with legitimate -N/-B options

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] Don't bail with legitimate -N/-B options
Дата
Msg-id 26805.1204924150@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCH] Don't bail with legitimate -N/-B options  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I wrote:
> Anyway, it seems that we cannot raise the minimum value of
> shared_buffers to 200, or even 100, unless we are prepared to blow off
> SHMMAX = 2MB or do something about the fixed SLRU allocation.

After further thought I propose that we just eliminate the interlock
between -N and -B.  I don't think it's accomplishing anything very
useful (for sure it's not enough to guarantee that you can't run out of
pinnable buffers), and the addition of the autovac worker processes
makes the whole thing too confusing to be helpful.

I am still interested in a TODO of increasing the minimum allowed value
of shared_buffers, but that's really an independent issue.  And we can't
do very much there anyway until after eliminating the fixed-size-SLRU-
buffers problem.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)
Следующее
От: "Joseph S"
Дата:
Сообщение: BUG #4020: RFE: have way to log autovacuum activity