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
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2009-02-25 22:50:07|
|Subject: Re: Synchronous replication & Hot standby patches|
|Previous:||From: Simon Riggs||Date: 2009-02-25 21:34:41|
|Subject: Re: Hot standby, running xacts, subtransactions|