2013/3/18 Rodrigo Barboza <rodrigombu...@gmail.com>:
> So setting this as half of ram, as suggested in postgres tuning webpage
> should be safe?
> It says it is a conservative value...

depends how much memory is used as cache ??

it can be a shared_buffers + file system cache

Regards

Pavel Stehule

>
>
> On Mon, Mar 18, 2013 at 3:18 PM, Pavel Stehule <pavel.steh...@gmail.com>
> wrote:
>>
>> 2013/3/18 Pavel Stehule <pavel.steh...@gmail.com>:
>> > Hello
>> >
>> > 2013/3/18 Rodrigo Barboza <rodrigombu...@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
>>
>> wrong reply - Rob has true
>>
>> Pavel
>>
>> >
>> > Regards
>> >
>> > Pavel
>
>


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to