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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
