Scott Marlowe wrote:
With a 24 drive RAID-10 array that can read at ~1GB/s I am almost always CPU bound during copies. This isn't wholly bad as it leaves spare IO for the rest of the machine so regular work carries on just fine.
And you don't need nearly that much I/O bandwidth to reach that point. I've hit being CPU bound on COPY...FROM on systems with far less drives than 24.
-- Greg Smith 2ndQuadrant US [email protected] Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
