Re: Changing the default configuration (was Re:

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: Changing the default configuration (was Re:
Дата
Msg-id Pine.NEB.4.51.0302120934450.6267@angelic.cynic.net
обсуждение исходный текст
Ответ на Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Changing the default configuration (was Re:  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-advocacy
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@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

В списке pgsql-advocacy по дате отправления:

Предыдущее
От: "Rick Gigger"
Дата:
Сообщение: Re: [HACKERS] Changing the default configuration (was Re:
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: [HACKERS] Changing the default configuration (was Re: