On Thu, Jun 16, 2011 at 2:08 PM, Alexander Farber
<alexander.farber@gmail.com> wrote:
> It shows (but I have switched pgbouncer from session
> to transaction mode now and it seems to have helped -
> Drupal+my scripts are running again and pg_top shows
> 2-3 SELECTs at the top and the rest is "idle"):
>
> # vmstat 1
> procs -----------memory---------- ---swap-- -----io---- --system--
> -----cpu------
> r b swpd free buff cache si so bi bo in cs us sy id wa st
> 3 1 0 2896644 30748 617744 0 0 70 359 350 260 61
> 1 37 1 0
> 2 0 0 2875252 30760 619516 0 0 8 140 1333 1231 46
> 1 53 0 0
> 2 0 0 2873888 30768 618160 0 0 0 332 1293 1294 59
> 1 40 1 0
> 2 0 0 2871904 30768 619920 0 0 0 16 1257 453 38
> 0 61 0 0
> 4 0 0 2872896 30768 618136 0 0 0 24 1204 574 51
> 1 48 0 0
> 2 1 0 2868308 30768 622096 0 0 0 5608 1304 603 66
> 1 33 0 0
> 2 0 0 2870628 30780 620688 0 0 0 236 1329 999 53
> 1 46 2 0
I assume that this is with things working properly. Keep an eye on it
when the server is running slow to see what's changing. So far it
looks like that one change may have made a difference but I wouldn't
assume you're completely out of the woods just yet.
