Re: PostgreSQL 8.4.8 bringing my website down every evening

On Thu, Jun 16, 2011 at 2:08 PM, Alexander Farber
<alexander(dot)farber(at)gmail(dot)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.