Re: effective_cache_size on 32-bits postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
2013/3/18 Pavel Stehule <pavel.stehule@xxxxxxxxx>:
> Hello
>
> 2013/3/18 Rodrigo Barboza <rodrigombufrj@xxxxxxxxx>:
>> 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

wrong reply - Rob has true

Pavel

>
> Regards
>
> Pavel


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux