Re: Multiple Indexing, performance impact

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Daniel Åkerud <zilch(at)home(dot)se>, PostgreSQL-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multiple Indexing, performance impact
Date: 2001-06-22 22:02:45
Message-ID: 6081.993247365@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-06-22 22:06:38 Re: Multiple Indexing, performance impact
Previous Message Bruce Momjian 2001-06-22 21:56:46 Re: web site suggestion

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-06-22 22:06:38 Re: Multiple Indexing, performance impact
Previous Message Tom Lane 2001-06-22 21:58:39 Re: Extracting metadata about attributes from catalog