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