| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: RAID Controller (HP P400) beat by SW-RAID? |
| Date: | 2011-09-12 02:12:16 |
| Message-ID: | 201109111912.17064.ahodgson@simkin.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2011-09-12 02:25:22 | Re: RAID Controller (HP P400) beat by SW-RAID? |
| Previous Message | Claudio Freire | 2011-09-11 23:50:09 | Re: Postgres for a "data warehouse", 5-10 TB |