Re: [GENERAL] Multiple Indexing, performance impact - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Multiple Indexing, performance impact
Date
Msg-id 6081.993247365@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Multiple Indexing, performance impact  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [GENERAL] Multiple Indexing, performance impact  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: plperl doc
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Multiple Indexing, performance impact