On Thu, Mar 12, 2009 at 9:32 PM, Laurent Laborde <kerdezixe@xxxxxxxxx> wrote: > On Wed, Mar 11, 2009 at 11:42 PM, Frank Joerdens <frank@xxxxxxxxxxx> wrote: >> >> effective_cache_size = 4GB > > Only 4GB with 64GB of ram ? I'd been overly cautious lately with config changes as it's been difficult to argue for downtime and associated service risk. Changed it to 48 GB now since it doesn't require a restart which I'd missed. Thanks for spotting! Regards, Frank -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance