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

Поиск
Список
Период
Сортировка
От Nicolas Michel
Тема Re: Vacuum analyse after a long time without one ...
Дата
Msg-id 4AAA9173.1020506@lemail.be
обсуждение исходный текст
Ответ на Re: Vacuum analyse after a long time without one ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Tom Lane a écrit :
> 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
>
Thank you for your advices.I will follow them.

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

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