Re: [PERFORM] How to investiage slow insert problem

On Mon, Aug 19, 2013 at 10:44 PM, Rural Hunter wrote: > Hi, > > I'm on 9.2.4 with Ubuntu server. There are usually hundereds of > connections doing the same insert with different data from different > networks every minute, through pgbouncer in the same network of the > database server. The databa

Re: [PERFORM] How to investiage slow insert problem

(@Jeff, sorry I sent this message only to you by mistake, sending to the list now...) On Tue, Aug 20, 2013 at 9:24 PM, Jeff Janes wrote: > On Mon, Aug 19, 2013 at 10:30 PM, Rural Hunter > wrote: > > 于 2013/8/20 12:34, Jeff Janes 写道: > > > > > > How long had they been hanging there? It makes a

Re: [PERFORM] Function execute slow down in 9.2

2013/8/16 Александр Белинский > 12.08.2013 18:24, Pavel Stehule пишет: > > Hello >> >> it looks like known issue of sometimes dysfunctional plan cache in >> plpgsql in 9.2. >> >> similar issuehttp://postgresql.**1045698.n5.nabble.com/** >> Performance-problem-in-**PLPgSQL-td5764796.html