Re: [PERFORM] insert performance

On Sat, Jan 9, 2016 at 9:57 PM, Jinhua Luo wrote: > > To make a clean test env, I clone a new table, removing the indexes (keeping > the primary key) and triggers, and use pgbench to test insert statement > purely. Can you share the pgbench command line, and the sql file you

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

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

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

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