Re: Postgresql performance on Opteron 8 CPU

> 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