The database is 8gb currently. Use to be a lot bigger but we removed all large objects out and developed a file server storage for it, and using default page costs for 8.4, I did have it changed in 8.1.4 -----Original Message----- From: Robert Haas [mailto:robertmhaas@xxxxxxxxx] Sent: Sunday, 2 August 2009 11:26 PM To: Chris Dunn Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Performance 8.4.0 On Fri, Jul 31, 2009 at 12:22 AM, Chris Dunn<chris.dunn@xxxxxxxxxxxxx> wrote: > constraint_exclusion = on This is critical if you need it, but a waste of CPU time if you don't. Other than that your paramaters look good. Are you using the default page cost settings? I see you have 12 GB RAM; how big is your database? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
