On Tue, Feb 2, 2010 at 3:47 PM, Andy Colson <andy@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
