Re: performance tuning: shared_buffers, sort_mem; swap

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance tuning: shared_buffers, sort_mem; swap
Дата
Msg-id 7558.1029332461@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: performance tuning: shared_buffers, sort_mem; swap  (David Gilbert <dgilbert@velocet.ca>)
Ответы Re: performance tuning: shared_buffers, sort_mem; swap
Список pgsql-admin
David Gilbert <dgilbert@velocet.ca> writes:
> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
> Tom> Well, I must say this is the first time I've heard of "BSD-style
> Tom> shared memory".

> The canonical example is to mmap() a file multiply.

Oh.  Yes, as Curt said, this issue has been beaten to death already;
see the archives.

You could in fact use a MAP_ANON region as a replacement for SysV shared
memory, but AFAICT you would lose a rather important interlock against
starting a new postmaster when old backends remain alive.  Ugly as the
SysV API is, it does some things we need rather nicely.

> One bonus of bsd shared memory (when anonymous) is that it dies with
> the process ... even in the worst case.

But in fact we don't *want* it to be anonymous.

            regards, tom lane

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

Предыдущее
От: David Gilbert
Дата:
Сообщение: Re: performance tuning: shared_buffers, sort_mem; swap
Следующее
От: Thomas O'Connell
Дата:
Сообщение: Re: performance tuning: shared_buffers, sort_mem; swap