Re: Postgresql performance on Opteron 8 CPU - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Postgresql performance on Opteron 8 CPU
Date
Msg-id 42CEFE8A.3090404@commandprompt.com
Whole thread Raw
In response to Postgresql performance on Opteron 8 CPU  (Ericson Smith <eric@did-it.com>)
List 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

pgsql-general by date:

Previous
From:
Date:
Subject: pg_user does not exist
Next
From: Michael Fuhr
Date:
Subject: Re: Postgresql 7.4.8 inconsistent index usage