Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly

2016-01-11 Thread Skarsol
On Fri, Nov 13, 2015 at 3:50 PM, Jim Nasby wrote: > On 11/11/15 11:57 AM, Skarsol wrote: > >> Are we doing anything weird with this procedure? Is there anything more >> I can do to get more info as to why/how the cancellation is happening or >> why the function would

Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly

2016-01-11 Thread Jim Nasby
On 1/11/16 1:32 PM, Skarsol wrote: pgbouncer (S-0x17fd780 entries): 2016-01-11 12:21:46.600 32905 LOG S-0x17fd780: edi01/editor@127.0.0.1:6432 closing because: server idle timeout (age=612) 2016-01-11 12:23:28.142 32905 LOG S-0x17fd780: edi01/editor@127.0.0.1:6432

Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly

2016-01-11 Thread Skarsol
On Mon, Jan 11, 2016 at 1:39 PM, Jim Nasby wrote: > On 1/11/16 1:32 PM, Skarsol wrote: > >> pgbouncer (S-0x17fd780 entries): >> 2016-01-11 12:21:46.600 32905 LOG S-0x17fd780: >> edi01/editor@127.0.0.1:6432 closing >> because: server idle

Re: [PERFORM] Queries getting canceled inside a proc that seems to slow down randomly

2015-11-13 Thread Jim Nasby
On 11/11/15 11:57 AM, Skarsol wrote: Are we doing anything weird with this procedure? Is there anything more I can do to get more info as to why/how the cancellation is happening or why the function would slow down seemingly randomly? ERROR: canceling statement due to user request CONTEXT: