John R Pierce <pierce <at> hogranch.com> writes: > more likely, he's disk IO bound, but hard to say as that iostat output > only showed a couple 2 second slices of work. the first output, which > shows average since system startup, seems to show the system has had > relatively high average wait times of 100ms on the average, yet the > samples below only show 0, 2, 3mS await. I don't think the problem is disk I/O. The database easily fits in the available RAM (in fact there is a ton of RAM free) and iostat does not show a heavy load. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
