| From: | "Sheena, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)com> |
|---|---|
| To: | "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: | pg bouncer issue what does sv_used column means |
| Date: | 2015-06-12 17:57:22 |
| Message-ID: | 13E39D789E19FF4E9A87F6D456F3F982E90F30@SEAMBX03.sea.corp.int.untd.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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 | Jack Christensen | 2015-06-12 18:54:30 | log_statement = 'mod' does not log all data modifying statements |
| Previous Message | Francisco Olarte | 2015-06-12 17:45:44 | Re: double precision[] storage space questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glyn Astill | 2015-06-12 19:01:29 | Re: pg bouncer issue what does sv_used column means |
| Previous Message | Johann Spies | 2015-06-12 15:04:48 | Re: Slow query - lots of temporary files. |