Re: Tunning FreeeBSD and PostgreSQL

От: Bruce Momjian
Тема: Re: Tunning FreeeBSD and PostgreSQL
Дата: ,
Msg-id: 200307212041.h6LKfbi14090@candle.pha.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera)
Ответы: Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera)
Список: pgsql-performance

Скрыть дерево обсуждения

Tunning FreeeBSD and PostgreSQL  ("Stephen Howie", )
 Re: Tunning FreeeBSD and PostgreSQL  (Richard Huxton, )
 Re: Tunning FreeeBSD and PostgreSQL  ("Stephen Howie", )
  Re: Tunning FreeeBSD and PostgreSQL  ("Nick Fankhauser", )
 Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera, )
  Re: Tunning FreeeBSD and PostgreSQL  (Bruce Momjian, )
   Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera, )
    Re: Tunning FreeeBSD and PostgreSQL  (Bruce Momjian, )
     Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera, )
 Re: Tunning FreeeBSD and PostgreSQL  ("Stephen Howie", )
  Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera, )

Vivek Khera wrote:
> >>>>> "SH" == Stephen Howie <> writes:
>
> SH> Richard-
> SH> That was very helpfull Thanks!
> SH> I still would like some guidance on tunning FreeBSD (shmmax and shmmaxpgs).
> SH> Do I need to even touch these settings?
>
> Here's what I use on FreeBSD 4.7/4.8.  The kernel settings don't hurt
> anything being too large for the SHM values, since they are limits,
> not anything pre-allocated (from my understanding).  These settings
> allow for up to 100,000 shared buffers (I currently only use 30,000
> buffers)

I think the only downside to making them too big is that you allocate
page tables and prevent that address range from being used by other
processes.  Of course, if you have much less than 4 gigs of RAM in the
machine, it probably isn't an issue.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
                 |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073


В списке pgsql-performance по дате сообщения:

От: Christopher Browne
Дата:
Сообщение: Re: PGAvd
От: "Alexander Priem"
Дата:
Сообщение: Re: Tuning PostgreSQL