IO is active, but hardly saturated. CPU load is hefty though, load average is at 4 now.

procs memory swap io
system cpu
r b w swpd free buff cache si so bi bo in cs us sy id

0 2 1 2808 11432 39616 1902984 0 0 204 876 788 507 3 4 93

You're getting a load average of 4 with 93% idle?

That's a reasonable number of context switches, and if the blocks you're reading/writing are discontinous, I could see io saturation rearing it's head.

This looks to me like you're starting and killing a lot of processes.

Is this thrashing psql connections, or is it one big query? What are your active processes?

Your effective cache size looks to be about 1900 megs (+- binary), assuming all of it is pg.


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to