Re: xmin horizon?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: CS DBA <cs_dba(at)consistentstate(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: xmin horizon?
Date: 2015-07-30 01:16:38
Message-ID: CAB7nPqRcc3Q76fE1_8CJ-gR7k9C2Na2NuPrinb6eJ3Jryc3uHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 30, 2015 at 4:13 AM, CS DBA <cs_dba(at)consistentstate(dot)com> wrote:
> The documentation for pg_stat_activity lists this column:
>
> backend_xmin xid The current backend's xmin horizon.
>
> Can someone point me to a better understanding on "xmin horizon"?

This defines the oldest transaction ID that a given backend is currently seeing.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2015-07-30 01:21:55 Re: xmin horizon?
Previous Message Sherrylyn Branchaw 2015-07-30 00:27:07 Re: Question about copy from with timestamp format