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.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 >
