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.com
PostgreSQL Training, Services and Support