[GENERAL] performance tips please

2006-06-21 Thread Hugo 
Hi, I am testing my application and DB (postgres 8.1.4 ) on a : DELL-Power Edge
1800 with 2 Xeon 3.2ghz, 2 Gb RAM and 2 SCSI 149 Gb each.trouble is that the same application and DB(postgres 8.0.4) runs on a: DELL pentium 3 with 526MB of   RAM and an IDE 20 GB and comparing the performance of both, a get only 20-30seconds faster responses on the new server, where can I start looking to find out why is the second server performing this way.
any advice is very appreciated,thanks in advanceHugo

Re: [GENERAL] performance tips please

2006-06-21 Thread Tomi NA 

On 6/21/06, Hugo [EMAIL PROTECTED] wrote:

Hi, I am testing my application and DB (postgres 8.1.4 ) on a :
DELL-Power Edge 1800 with 2 Xeon 3.2ghz,  2 Gb RAM and 2 SCSI 149 Gb
each.
trouble is that the same application and DB(postgres 8.0.4) runs on a:
 DELL pentium 3 with 526MB of RAM and an IDE 20 GB

and comparing the performance of both, a get only 20-30seconds faster
responses on the new server, where can I start looking to find out why is
the second server performing this way.

any advice is very appreciated,

thanks in advance

Hugo



I assume the the task takes longer than 5 seconds to complete?
Are you running the same OS? Can pgsql distribute the load on both
Xeon processors? Is pgsql custom compiled for a specific architecture
(Pentium III, for example)? How do you measure the response time? Are
there other apps involved?

t.n.a.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

Fwd: [GENERAL] performance tips please

2006-06-21 Thread Hugo 
I assume the the task takes longer than 5 seconds to complete?
Are you running the same OS? Can pgsql distribute the load on both
Xeon processors? Is pgsql custom compiled for a specific architecture(Pentium III, for example)? How do you measure the response time? Arethere other apps involved?t.n.a.
The DELL PIII box runs FC4 , the config is the default one.
The DELL Xeon runs SUSE 10.0, the config has some changes to improve autovacuum, thats all.I just downloaded the source and follow the tipical install instructions on both machines.The application takes the start and end time of the query, mainly it is a reporting application running on a WinXP client.
thanksHugo