Horton

Re: Postgresql performance on Opteron 8 CPU

Joshua D. Drake <jd@commandprompt.com>

View thread View on postgr.es
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Ericson Smith <eric@did-it.com>
Cc: pgsql-general@postgresql.org
Date: 2005-07-08T22:30:34Z
Lists: pgsql-general 
> Does anyone have suggestions that could improve performance?

If you have doubled your ram you could definately increase your 
effective_cache.

As you also doubled your memory you could increase your work_mem but be 
careful with this setting.

Also just to be certain are you running 32bit or 64bit PostgreSQL?

Sincerely,

Joshua D. Drake


> 
> 
> ------------------------------------------------------------------------
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq


-- 
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org