Re: [GENERAL] Best memory/planner settings for Postgres

2008-11-04 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Thom Brown > Sent: Tuesday, November 04, 2008 1:45 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Best memory/planner settings for Postgres > > We

[GENERAL] Best memory/planner settings for Postgres

2008-11-04 Thread Thom Brown
We've got a dedicated database server running PostgresSQL 8.0.9 (yes, I know it needs upgrading), but I've noticed it looks criminally under-configured. Basically it's running on a server with 2 dual-core Intel Xeon 2.33 Ghz processors and 4Gb memory, but has the following settings in postgresql.c