On Tue, Feb 2, 2010 at 3:47 PM, Andy Colson <a...@squeakycode.net> wrote: >> effective_cache_size = 5000MB > > I see your running a 32bit, but with bigmem support, but still, one process > is limited to 4gig. You'd make better use of all that ram if you switched > to 64bit. And this cache, I think, would be limited to 4gig.
Just to be clear, effective_cache_size does not allocate any memory of any kind, in any way, ever... ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
