| From: | Xenofon Papadopoulos <xpapad(at)gmail(dot)com> |
|---|---|
| To: | |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: pg bouncer issue what does sv_used column means |
| Date: | 2015-06-12 20:26:36 |
| Message-ID: | CANL7jAQZroMS9ATzo5q16ru6pyH2W=4vgyuoTmOK_zUaK_+SxA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Unsubscribe
On Fri, Jun 12, 2015 at 8:57 PM, Sheena, Prabhjot <
Prabhjot(dot)Singh(at)classmates(dot)com> wrote:
> Guys we see spike in pg bouncer during the peak hours and that was
> slowing down the application. We did bump up the connection limit and it is
> helpful but now we again notice little spike in connection. And one thing
> that I notice that is different is jump in sv_used value when I run command
> show pools during problem times
>
>
>
>
>
> *Can anyone please explain what value of sv_used means when i run show
> pools;*
>
>
>
>
>
>
> Regards
>
> *Prabhjot *
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sheena, Prabhjot | 2015-06-12 21:37:36 | Re: pg bouncer issue what does sv_used column means |
| Previous Message | Glyn Astill | 2015-06-12 19:01:29 | Re: pg bouncer issue what does sv_used column means |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Nolan | 2015-06-12 20:37:00 | Are there tuning parameters that don't take effect immediately? |
| Previous Message | Glyn Astill | 2015-06-12 19:01:29 | Re: pg bouncer issue what does sv_used column means |