On 11 March 2010 16:16, Ben Chobot <bench@xxxxxxxxxxxxxxx> wrote: > I *can* say a 10GB shared_buffer value is working "well" with my 128GB of RAM..... whether or not it's "optimal," I couldn't say without a lot of experimentation I can't afford to do right now. You might have a look at the pg_buffercache contrib module. It can tell you how utilized your shared buffers are. Thanks Ben and Greg, I shall start with something relatively sane (such as 10GB) and then see how we go from there. Once this server has brought online and bedded in I will be updating our other three servers which are identical in hardware spec and all have the same replicated data so I'll be able to do some real world tests with different settings withn the same load. (Currently one is currently running postgresql 8.1 on 32bit OS under a VM, the other two running 8.3 on 64bit OS with 64gig of memory but with Postgres still tuned for the 8 gigs the servers originally had and under a VM). Paul -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
