Skip site navigation (1) Skip section navigation (2)

Re: Changing the default configuration (was Re:

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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: Changing the default configuration (was Re:
Date: 2003-02-12 00:41:45
Message-ID: Pine.NEB.4.51.0302120934450.6267@angelic.cynic.net (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
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.)

cjs
-- 
Curt Sampson  <cjs(at)cynic(dot)net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

In response to

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2003-02-12 00:42:06
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Previous:From: Rick GiggerDate: 2003-02-12 00:25:29
Subject: Re: [HACKERS] Changing the default configuration (was Re:

pgsql-hackers by date

Next:From: scott.marloweDate: 2003-02-12 00:42:06
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Previous:From: scott.marloweDate: 2003-02-12 00:32:58
Subject: Re: Changing the default configuration (was Re:

pgsql-advocacy by date

Next:From: scott.marloweDate: 2003-02-12 00:42:06
Subject: Re: [HACKERS] Changing the default configuration (was Re:
Previous:From: Rick GiggerDate: 2003-02-12 00:25:29
Subject: Re: [HACKERS] Changing the default configuration (was Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group