| From: | "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com> |
|---|---|
| To: | "Porell, Chris" <Chris(dot)Porell(at)ceridian(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Database performance problem |
| Date: | 2007-06-12 20:41:58 |
| Message-ID: | b35603930706121341i384b9e92i4c26e02b48b000e1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 6/13/07, Porell, Chris <Chris(dot)Porell(at)ceridian(dot)com> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Porell, Chris | 2007-06-12 20:56:10 | Re: Database performance problem |
| Previous Message | Steve Crawford | 2007-06-12 20:35:25 | Re: Database performance problem |