From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: RAID Controller (HP P400) beat by SW-RAID?
Date: Sun, 11 Sep 2011 19:12:16 -0700
Message-ID: <201109111912.17064.ahodgson@simkin.ca> (raw)
In-Reply-To: <CAO2AxyoGvmRYtq=1=weOU_CCnAxK8FboBa8GWS6XZ923CXCCgA@mail.gmail.com>
References: <CAO2AxyoGvmRYtq=1=weOU_CCnAxK8FboBa8GWS6XZ923CXCCgA@mail.gmail.com>
On September 11, 2011 03:44:34 PM Anthony Presley wrote:
> First thing I noticed is that it takes the same amount of time to load the
> db (about 40 minutes) on the new hardware as the old hardware. I was
> really hoping with the faster, additional drives and a hardware RAID
> controller, that this would be faster. The database is only about 9GB
> with pg_dump (about 28GB with indexes).
Loading the DB is going to be CPU-bound (on a single) core, unless your disks
really suck, which they don't. Most of the time will be spent building
indexes.
I don't know offhand why the queries are slower, though, unless you're not
getting as much cached before testing as on the older box.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: RAID Controller (HP P400) beat by SW-RAID?
In-Reply-To: <201109111912.17064.ahodgson@simkin.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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