Skip site navigation (1) Skip section navigation (2)

Re: Hot standby, running xacts, subtransactions

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Hot standby, running xacts, subtransactions
Date: 2009-02-25 21:43:54
Message-ID: 1235598234.16176.373.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2009-02-25 22:50:07
Subject: Re: Synchronous replication & Hot standby patches
Previous:From: Simon RiggsDate: 2009-02-25 21:34:41
Subject: Re: Hot standby, running xacts, subtransactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group