2013/3/18 Rodrigo Barboza <rodrigombufrj@xxxxxxxxx>: > 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.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 > > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
