Re: Changing the default configuration (was Re: [pgsql-advocacy] - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: Changing the default configuration (was Re: [pgsql-advocacy]
Date
Msg-id Pine.LNX.4.33.0302111800080.1977-100000@css120.ihs.com
Whole thread Raw
In response to Re: Changing the default configuration (was Re: [pgsql-advocacy]  (Curt Sampson <cjs@cynic.net>)
List pgsql-hackers
On Wed, 12 Feb 2003, Curt Sampson wrote:

> On Tue, 11 Feb 2003, Tom Lane wrote:
>
> > It's a lot too conservative.  I've been thinking for awhile that we
> > should adjust the defaults.
>
> Some of these issues could be made to Just Go Away with some code
> changes. For example, using mmap rather than SysV shared memory
> would automatically optimize your memory usage, and get rid of the
> double-buffering problem as well. If we could find a way to avoid using
> semephores proportional to the number of connections we have, then you
> wouldn't have to worry about that configuration parameter, either.
>
> In fact, some of this stuff might well improve our portability, too.
> For example, mmap is a POSIX standard, whereas shmget is only an X/Open
> standard. That makes me suspect that mmap is more widely available on
> non-Unix platforms. (But I could be wrong.)

I'll vote for mmap.  I use the mm libs with apache/openldap/authldap and
it is very fast and pretty common nowadays.  It seems quite stable as
well.


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Changing the default configuration
Next
From: Bruno Wolff III
Date:
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]