From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Ericson Smith <eric(at)did-it(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql performance on Opteron 8 CPU |
Date: | 2005-07-08 22:30:34 |
Message-ID: | 42CEFE8A.3090404@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-07-08 22:53:56 | Re: Postgresql 7.4.8 inconsistent index usage |
Previous Message | Enrico Riedel | 2005-07-08 21:43:41 | PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea Value in stored procedure |