Re: pg_subtrans keeps bloating up in the standby - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: pg_subtrans keeps bloating up in the standby
Date
Msg-id 1283159929.1800.1843.camel@ebony
Whole thread Raw
In response to Re: pg_subtrans keeps bloating up in the standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: pg_subtrans keeps bloating up in the standby
List pgsql-hackers
On Mon, 2010-08-30 at 09:59 +0300, Heikki Linnakangas wrote:

> However, is it safe to use GetOldestXMin() during recovery? Or to put it
> other way, is GetOldestXMin() functioning correctly during hot standby?
> It only scans through the ProcArray, but not the known-assigned xids
> array. That seems like an oversight that needs to be fixed.

Patch to implement that attached.

This is necessary since CreateCheckpoint is called during end of
recovery, though at that point there are still xids in KnownAssignedXids
since they aren't removed until slightly later. Not hugely important.

Also allows GetOldestXmin to be safely called elsewhere, such as Fujii's
earlier patch on this thread.

Any objections to commit to both head and 9.0?

Will then commit Fujii's patch.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Development, 24x7 Support, Training and Services

Attachment

pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: bg worker: patch 1 of 6 - permanent process
Next
From: Simon Riggs
Date:
Subject: Re: Exposing the Xact commit order to the user