On 6/13/07, Porell, Chris <[EMAIL PROTECTED]> wrote:
Hi All,
[...]
the SQL in psql. The old server was a dual AMD opteron 2.6 GHz machine with a RAID 5 array and 4GB memory. The new machine is a dual dual-core AMD Opteron 2.6GHz with RAID 1 and 16GB memory.
[...]
On my new DB server, it takes about 27 seconds for this query to run. On the old server, it takes 2 seconds.
[...]
Any ideas?
How many spindles were there in the RAID-5 on the old box, how many in the RAID-1 on the new one? What kind of controller?
Thanks! Chris
Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
