Re: Troubles with performances

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Troubles with performances
Дата
Msg-id 200101191303.IAA06518@jupiter.jw.home
обсуждение исходный текст
Ответ на Re: Troubles with performances  (Lamar Owen <lamar.owen@wgcr.org>)
Список pgsql-general
Lamar Owen wrote:
>
> /*
>  * _SHM_ID_BITS + _SHM_IDX_BITS must be <= 24 on the i386 and
>  * SHMMAX <= (PAGE_SIZE << _SHM_IDX_BITS).
>  */
>
> #define SHMMAX 0x2000000                /* max shared seg size (bytes)
> */
> /* Try not to change the default shipped SHMMAX - people rely on it */
>
> -------
>
> Hmmmm....
>
> Looks pretty difficult to change.

    echo 134217728 >/proc/sys/kernel/shmmax

    set's  the  maximum  allowed  segment!  size  to 128M. Shared
    memory under Linux can  be  swapped,  so  if  you  have  256M
    physical  and  run  3  postmasters, you can start all of them
    with 64M (or more) and while they're  idle  they  most  likey
    consume  some swap space. But when it poors, they'll grab the
    memory they need.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: order of triggers
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: RE: Why is there so much MySQL bashing???