Re: [GENERAL] Multiple Indexing, performance impact

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Multiple Indexing, performance impact
Дата
Msg-id 6081.993247365@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Multiple Indexing, performance impact  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [GENERAL] Multiple Indexing, performance impact  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> This does remind me that I'd been thinking of suggesting that we
>> raise the default -B to something more reasonable, maybe 1000 or so
>> (yielding an 8-meg-plus shared memory area).

> BSD/OS has a 4MB max but we document how to increase it by recompiling
> the kernel.

Hmm.  Anyone like the idea of a platform-specific default established
by configure?  We could set it in the template file on platforms where
the default SHMMAX is too small to allow 1000 buffers.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: plperl doc
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Multiple Indexing, performance impact