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 <khera@kcilink.com>)
Ответы Re: Tunning FreeeBSD and PostgreSQL  (Vivek Khera <khera@kcilink.com>)
Список pgsql-performance
Vivek Khera wrote:
> >>>>> "SH" == Stephen Howie <showie@centwire.com> 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
  pgman@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 по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Commenting postgresql.conf
Следующее
От: Josh Berkus
Дата:
Сообщение: PGAvd