Re: Hot standby, running xacts, subtransactions

On Wed, 2009-02-25 at 13:33 -0800, Josh Berkus wrote:
> > You raised that as an annoyance previously because it means that
> > connection in hot standby mode may be delayed in cases of heavy,
> > repeated use of significant numbers of subtransactions. 
> 
> While most users still don't use explicit subtransactions at all, 
> wouldn't this also affect users who use large numbers of stored procedures?

If they regularly use more than 64 levels of nested EXCEPTION clauses
*and* they start their base backups during heavy usage of those stored
procedures, then yes.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support