Re: Vacuum analyse after a long time without one ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum analyse after a long time without one ...
Дата
Msg-id 22271.1252687800@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum analyse after a long time without one ...  (Nicolas Michel <nicolas.michel@lemail.be>)
Ответы Re: Vacuum analyse after a long time without one ...  (Nicolas Michel <nicolas.michel@lemail.be>)
Re: Vacuum analyse after a long time without one ...  (Anj Adu <fotographs@gmail.com>)
Список pgsql-admin
Nicolas Michel <nicolas.michel@lemail.be> writes:
> - I have 16Go of RAM on that server (but 32bits OS with bigmem kernel ;
> so I set shared buffer to 350000 (~2,7GB) for a shmmax of 4000000000
> (~3,8GB)

On a 32-bit machine that's just insane.  You've got something like 300MB
left over in the process address space (assuming the typical 1Gb for
kernel split).  No wonder things are falling over.  Try putting
shared_buffers somewhere around 1Gb.  Or switch to 64-bit.

            regards, tom lane

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

Предыдущее
От: Nicolas Michel
Дата:
Сообщение: Re: Vacuum analyse after a long time without one ...
Следующее
От: Nicolas Michel
Дата:
Сообщение: Re: Vacuum analyse after a long time without one ...