Re: effective_cache_size on 32-bits postgres
| От | Rodrigo Barboza |
|---|---|
| Тема | Re: effective_cache_size on 32-bits postgres |
| Дата | |
| Msg-id | CANs8QJYt3C6TptfzEbCMSJvEwHh1prrtFhpNgXyc9P0z5ApANw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: effective_cache_size on 32-bits postgres (Pavel Stehule <pavel.stehule@gmail.com>) |
| Ответы |
Re: effective_cache_size on 32-bits postgres
Re: effective_cache_size on 32-bits postgres |
| Список | pgsql-performance |
So setting this as half of ram, as suggested in postgres tuning webpage should be safe?
It says it is a conservative value...
On Mon, Mar 18, 2013 at 3:18 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
2013/3/18 Pavel Stehule <pavel.stehule@gmail.com>:wrong reply - Rob has true> 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
Pavel
>
> Regards
>
> Pavel
В списке pgsql-performance по дате отправления: