Re: [PERFORM] auto vaccum is dying

2014-10-01 Thread Heikki Linnakangas
On 10/02/2014 07:43 AM, Rodrigo Barboza wrote: Hello, I have a table that receives lots of updates and inserts. Auto vaccum is always being cancelled on that table. One day the database went on standby and I had to act manually to recover. What should I do to avoid auto vaccum cancel? Cancella

[PERFORM] auto vaccum is dying

2014-10-01 Thread Rodrigo Barboza
Hello, I have a table that receives lots of updates and inserts. Auto vaccum is always being cancelled on that table. One day the database went on standby and I had to act manually to recover. What should I do to avoid auto vaccum cancel?

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-10-01 Thread Josh Berkus
On 09/30/2014 04:01 PM, Simon Riggs wrote: > On 30 September 2014 18:28, Jeff Janes wrote: > >>> Anyway, in the particular case I posted fixing n_distinct to realistic >>> numbers (%) fixed the query plan. >> >> >> But wouldn't fixing the absolute number also have fixed the plan? > > There are t