Rob Nagler <[EMAIL PROTECTED]> writes: > Here's the vmstat 5 at a random time:
> procs memory swap io system cpu > r b w swpd free buff cache si so bi bo in cs us sy id > 0 0 0 272372 38416 78220 375048 0 3 2 0 0 0 2 2 0 > 0 0 0 272372 30000 78320 375660 0 0 34 274 382 284 5 1 94 > 0 1 0 272372 23012 78372 375924 0 0 25 558 445 488 8 2 90 > 1 0 0 272368 22744 78472 376192 0 6 125 594 364 664 9 3 88 > And here's it during vacuum: > procs memory swap io system cpu > r b w swpd free buff cache si so bi bo in cs us sy id > 1 2 1 277292 9620 72028 409664 46 32 4934 4812 1697 966 8 4 88 > 0 3 0 277272 9588 72096 412964 61 0 7303 2478 1391 976 3 3 94 > 2 2 0 277336 9644 72136 393264 1326 32 2827 2954 1693 1519 8 3 89 The increased I/O activity is certainly to be expected, but what I find striking here is that you've got substantial swap activity in the second trace. What is causing that? Not VACUUM I don't think. It doesn't have any huge memory demand. But swapping out processes could account for the perceived slowdown in interactive response. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly