On Thu, Oct 30, 2008 at 07:28:57PM +0000, Joao Ferreira gmail wrote: > On Thu, 2008-10-30 at 11:39 -0700, Alan Hodgson wrote: > > You're probably just > > disk-bound, though. What does vmstat say during the restore? > > During restore: > # vmstat > procs --------memory------- ---swap-- -----io---- -system-- ----cpu---- > r b swpd free buff cache si so bi bo in cs us sy id wa > 3 1 230204 4972 1352 110128 2 1 17 63 24 56 12 2 85 0 > > > After restore has finished > # vmstat > procs --------memory-------- ---swap-- ---io---- -system-- ----cpu---- > r b swpd free buff cache si so bi bo in cs us sy id wa > 1 0 246864 59972 2276 186420 2 1 18 63 28 56 12 2 85 0 >From the output you've given it doesn't look as though you left vmstat running while the processing is running, the first set of numbers it prints out are rarely representational values for the IO usage. Try running "vmstat 5" to get output every 5 seconds, you should be able to see things happening a bit more easily that way. Another tool I'd recommend is iostat, I tend to invoke it as "iostat -mx 5 /dev/sd?" to get it to print out values for each individual disk. Sam -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
