You are getting 190+ secs on the new hardware and 235 secs on the old?
Is the CPU usage maxed out? Assuming linux run top and then press 1.
If in both cases the CPU's are maxed out, then that explains why they are
about the same speed = both are 3GHz Intel CPUs, and your DB fits in RAM.
I've really no idea how to improve your query or indexing...
Try EXPLAIN ANALYZE <your query here> and then look for the longest running
bits.
Link.
At 03:32 PM 6/1/2006 +0200, Philippe Lang wrote:
>Hi,
>
>I made some tests, with and without Hyperthreading: with hyperthreading, on
>a dual-processor, top mentions a 25% load, and without, 50%, but computing
>time is exactly the same.
>
>Philippe
>
>-----Message d'origine-----
>De : pgsql-general-owner@postgresql.org
>[mailto:pgsql-general-owner@postgresql.org] De la part de Arnaud Lesauvage
>Envoyé : mercredi, 31. mai 2006 16:20
>À : pgsql-general@postgresql.org
>Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem
>
>Philippe Lang a écrit :
> > Hardware is much more powerful: intel server motherboard, dual-xeon
> > 3GHz, SCSI disks (raid 1), 4GB RAM.
>
>Do you need the hyperthreading ?
>Depending on your case, you might have better results with 2x3GHz thant
>4x1.5GHz.
>
>--
>Arnaud
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>