Re: Optimisation help

Поиск
Список
Период
Сортировка
От Erik Jones
Тема Re: Optimisation help
Дата
Msg-id 82845731-D41C-4A79-9937-4A03CF455B36@myemma.com
обсуждение исходный текст
Ответ на Re: Optimisation help  (dforums <dforums@vieonet.com>)
Ответы Re: Optimisation help
Список pgsql-performance
On Mar 4, 2008, at 6:54 PM, dforums wrote:

> Hello,
>
> After controling the settings I so, that shared_buffers is
> configurated at 1024 (the default), however, in my postgresql.conf I
> set it to 250000, is it due to shared memory settings, should I
> increase shmmax?

Did you do a full restart of the db cluster?  Changes to shared memory
settings require that.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




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

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: Optimisation help
Следующее
От: dforums
Дата:
Сообщение: Re: Optimisation help