From: Martijn van Oosterhout <kleptog@svana.org>
To: Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
Date: Thu, 7 Aug 2003 19:30:07 +1000
Message-ID: <20030807093006.GA19280@svana.org> (raw)
In-Reply-To: <009d01c35c21$ba3a1270$70c0b4c8@notebook>
References: <009d01c35c21$ba3a1270$70c0b4c8@notebook>
On Wed, Aug 06, 2003 at 10:50:38AM -0300, Wilson A. Galafassi Jr. wrote:
> Hello.
> I have this problem: i'm running the postgre 7.3 on a windows 2000 server
> with P3 1GHZ DUAL/1gb ram with good performance. For best performance i
> have change the server for a XEON 2.4/1gb ram and for my suprise the
> performance decrease 80%. anybody have a similar experience? does exist
> any special configuration to postgre running on a Xeon processor? Any have
> any idea to help-me? Excuse-me my bad english.
I assume you've done the vacuums, analyze, configured the wal and shmem
option appropriate for that size machine.
But in any case, without specific examples about what you're seeing we can't
help you.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kleptog@svana.org, wgalafassijr@yahoo.com.br
Subject: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
In-Reply-To: <20030807093006.GA19280@svana.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox