From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Curt Sampson <cjs(at)cynic(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>, <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Changing the default configuration (was Re: |
Date: | 2003-02-12 01:02:09 |
Message-ID: | Pine.LNX.4.33.0302111800080.1977-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2003-02-12 01:10:00 | Re: [HACKERS] Changing the default configuration |
Previous Message | scott.marlowe | 2003-02-12 00:42:06 | Re: [HACKERS] Changing the default configuration (was Re: |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2003-02-12 01:10:00 | Re: [HACKERS] Changing the default configuration |
Previous Message | Greg Copeland | 2003-02-12 00:44:18 | Re: PGP signing release |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2003-02-12 01:10:00 | Re: [HACKERS] Changing the default configuration |
Previous Message | scott.marlowe | 2003-02-12 00:42:06 | Re: [HACKERS] Changing the default configuration (was Re: |