Re: Multiple Indexing, performance impact
От | Bruce Momjian |
---|---|
Тема | Re: Multiple Indexing, performance impact |
Дата | |
Msg-id | 200106222206.f5MM6cI26794@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Multiple Indexing, performance impact (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Multiple Indexing, performance impact
|
Список | pgsql-general |
> 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. Template file seems like a good idea for platforms that can't handle the default. I don't think configure should be doing such tests because the target could be a different kernel. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-general по дате отправления: