Re: [PERFORM] pg bouncer issue what does sv_used column means

2015-06-12 Thread k...@rice.edu
On Fri, Jun 12, 2015 at 09:37:36PM +, Sheena, Prabhjot wrote: > Here is some more information > > pool_mode | transaction > > We have transactional pooling and our application is set up in such a way > that we have one query per transaction. We have set default pool size to

Re: [PERFORM] pg bouncer issue what does sv_used column means

2015-06-12 Thread Andrew Dunstan
Please do not cross-post on the PostgreSQL lists. Pick the most appropriate list to post to and just post there. cheers andrew -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-perform

Re: [PERFORM] pg bouncer issue what does sv_used column means

2015-06-12 Thread Sheena, Prabhjot
Here is some more information pool_mode | transaction We have transactional pooling and our application is set up in such a way that we have one query per transaction. We have set default pool size to 100. This is output . As you guys can see active connection are 100 and 224 a

Re: [PERFORM] Are there tuning parameters that don't take effect immediately?

2015-06-12 Thread Michael Nolan
On Fri, Jun 12, 2015 at 4:52 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Jun 12, 2015 at 4:37 PM, Michael Nolan wrote: > >> The only thing I can come up that's happened since last night was that we >> ran the nightly vacuum analyze on that database, but I did not change t

Re: [PERFORM] Are there tuning parameters that don't take effect immediately?

2015-06-12 Thread Joshua D. Drake
On 06/12/2015 01:37 PM, Michael Nolan wrote: Last night I was doing some tuning on a database The longest query I was running was taking around 160 seconds. I didn't see much change in the running time for that query, even after restarting PG. Today, with roughly the same system load (possibl

Re: [PERFORM] Are there tuning parameters that don't take effect immediately?

2015-06-12 Thread David G. Johnston
On Fri, Jun 12, 2015 at 4:37 PM, Michael Nolan wrote: > The only thing I can come up that's happened since last night was that we > ran the nightly vacuum analyze on that database, but I did not change the > statistics target. > ​The answer to your question is no, parameters changes are worse w

[PERFORM] Are there tuning parameters that don't take effect immediately?

2015-06-12 Thread Michael Nolan
Last night I was doing some tuning on a database The longest query I was running was taking around 160 seconds. I didn't see much change in the running time for that query, even after restarting PG. Today, with roughly the same system load (possibly even a bit heavier load), that query is runnin

Re: [PERFORM] pg bouncer issue what does sv_used column means

2015-06-12 Thread Xenofon Papadopoulos
Unsubscribe On Fri, Jun 12, 2015 at 8:57 PM, Sheena, Prabhjot < prabhjot.si...@classmates.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

[PERFORM] pg bouncer issue what does sv_used column means

2015-06-12 Thread Sheena, Prabhjot
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 sh

Re: [PERFORM] Slow query - lots of temporary files.

2015-06-12 Thread Johann Spies
On 10 June 2015 at 16:50, Tomas Vondra wrote: > > > The problematic piece of the explain plan is this: > > -> Merge Join (cost=4384310.92..21202716.78 rows=6664163593 > width=390)" >Output: a.ut, c.gt, b.go, b.gn, d.au" >Merge Cond: ((c.ut)::text = (d.rart_id)