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.steh...@gmail.com>wrote: > 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 > > Regards > > Pavel >