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

Hot standby, running xacts, subtransactions

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Hot standby, running xacts, subtransactions
Date: 2009-02-25 20:39:55
Message-ID: 49A5AC9B.3010903@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-hackers
When we take the snapshot of running transactions in the master, in 
GetRunningTransactionData(), it only includes top-level xids and those 
subxids that are in the subxid caches. Overflowed subxids are not 
included. Isn't that a problem? When the standby initializes the 
recovery procs using the running xacts information, pg_subtrans doesn't 
isn't set for the overflowed xids, because that information is not 
included in the WAL record. If you're lucky, the information is there 
already, but we don't generally guarantee pg_subtrans to survive crash 
or restart.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2009-02-25 20:45:18
Subject: Re: Synchronous replication & Hot standby patches
Previous:From: Robert HaasDate: 2009-02-25 20:14:39
Subject: Re: Synchronous replication & Hot standby patches

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