pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql slow on XEON 2.4ghz/1gb ram
4+ messages / 4 participants
[nested] [flat]
* Postgresql slow on XEON 2.4ghz/1gb ram
@ 2003-08-06 13:50 Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>
2003-08-07 09:30 ` Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Martijn van Oosterhout <kleptog@svana.org>
0 siblings, 1 reply; 4+ messages in thread
From: Wilson A. Galafassi Jr. @ 2003-08-06 13:50 UTC (permalink / raw)
To: pgsql-sql
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.
Very Thanks
Wilson
icq 77032308
msn wgalafassijr@hotmail.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
2003-08-06 13:50 Postgresql slow on XEON 2.4ghz/1gb ram Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>
@ 2003-08-07 09:30 ` Martijn van Oosterhout <kleptog@svana.org>
0 siblings, 0 replies; 4+ messages in thread
From: Martijn van Oosterhout @ 2003-08-07 09:30 UTC (permalink / raw)
To: Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
@ 2003-08-06 22:04 Maksim Likharev <mlikharev@aurigin.com>
2003-08-07 15:43 ` Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 4+ messages in thread
From: Maksim Likharev @ 2003-08-06 22:04 UTC (permalink / raw)
To: Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>; pgsql-sql
What OS, if Linux what kernel
-----Original Message-----
From: Wilson A. Galafassi Jr. [mailto:wgalafassijr@yahoo.com.br]
Sent: Wednesday, August 06, 2003 6:51 AM
To: pgsql-sql@postgresql.org
Subject: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
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.
Very Thanks
Wilson
icq 77032308
msn wgalafassijr@hotmail.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
2003-08-06 22:04 Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Maksim Likharev <mlikharev@aurigin.com>
@ 2003-08-07 15:43 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 4+ messages in thread
From: Robert Treat @ 2003-08-07 15:43 UTC (permalink / raw)
To: Maksim Likharev <mlikharev@aurigin.com>; +Cc: Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>; pgsql-sql
If you went from a dual processor box running windows to a single
processor box running windows, I wouldn't be surprised to see a slow
down. I'd recommend switching from Windows to Linux/BSD over a hardware
upgrade any day.
Robert Treat
On Wed, 2003-08-06 at 18:04, Maksim Likharev wrote:
> What OS, if Linux what kernel
>
> -----Original Message-----
> From: Wilson A. Galafassi Jr. [mailto:wgalafassijr@yahoo.com.br]
> Sent: Wednesday, August 06, 2003 6:51 AM
> To: pgsql-sql@postgresql.org
> Subject: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
>
>
>
> 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.
> Very Thanks
> Wilson
> icq 77032308
> msn wgalafassijr@hotmail.com
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-08-07 15:43 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-06 13:50 Postgresql slow on XEON 2.4ghz/1gb ram Wilson A. Galafassi Jr. <wgalafassijr@yahoo.com.br>
2003-08-07 09:30 ` Martijn van Oosterhout <kleptog@svana.org>
2003-08-06 22:04 Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Maksim Likharev <mlikharev@aurigin.com>
2003-08-07 15:43 ` Robert Treat <xzilla@users.sourceforge.net>
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