Re: effective_cache_size on 32-bits postgres

Поиск
Список
Период
Сортировка
От Rodrigo Barboza
Тема Re: effective_cache_size on 32-bits postgres
Дата
Msg-id CANs8QJaNdx0Y7jK5a7rEC0kfQCXHGQsTXeuMbu3Ep1xMCTUr0g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: effective_cache_size on 32-bits postgres  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-performance
Ok, now I'm lost, who is right about the limit? Rob or Pavel?

Rob, I know it should be a 64 bit, and it will be soon, but there are good reasons for this scenario and it's ok for now.


On Mon, Mar 18, 2013 at 3:15 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hello

2013/3/18 Rodrigo Barboza <rodrigombufrj@gmail.com>:
> Hi guys, I am worried about the effective_cache_size.
> I run a 32-bits postgres installation on a machine with 64 bits kernel.
> Should I limit effective_cache_size to a maximum of 2.5gb?

sure and probably little bit less

Regards

Pavel

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: effective_cache_size on 32-bits postgres
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: effective_cache_size on 32-bits postgres