Postgres Pro
Downloads
Home   >   mailing lists

Re: effective_cache_size on 32-bits postgres - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: effective_cache_size on 32-bits postgres
Date
Msg-id CAFj8pRDJu4-6ZDVttqePbZv4euCMDLT=N0T5L0DmA6uv_yCbLQ@mail.gmail.com
Whole thread Raw
In response to effective_cache_size on 32-bits postgres  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Responses Re: effective_cache_size on 32-bits postgres
Re: effective_cache_size on 32-bits postgres
List pgsql-performance
Tree view 
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 by date:

Previous
From: Rob Wultsch
Date:
Subject: Re: effective_cache_size on 32-bits postgres
Next
From: Rodrigo Barboza
Date:
Subject: Re: effective_cache_size on 32-bits postgres