Re: Finding if old transactions are running...

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Finding if old transactions are running...
Date: 2005-02-24 05:32:36
Message-ID: 38577kF5lcg23U1@individual.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I can see this function available in the backend:

TransactionId GetOldestXmin(bool alldbs);

The cost is based on walking thru each backend process, which I guess
is obvious, as if there are 47 backends, that means 47 xids.
Presumably not _too_ expensive; certainly something that has to be run
every time a vacuum is requested.

Is there a way to expose this?
--
output = ("cbbrowne" "@" "gmail.com")
http://linuxdatabases.info/info/languages.html
If you're not part of the solution, you're part of the precipitate.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bjoern Metzdorf 2005-02-24 07:41:53 Re: invalid multibyte character for locale
Previous Message Bruce Momjian 2005-02-24 05:12:37 Re: psql: recall previous command?