xmin horizon?
All;
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"?
Thanks in advance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Jul 30, 2015 at 4:13 AM, CS DBA <cs_dba@consistentstate.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 29/07/15 21:13, CS DBA 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"?
https://momjian.us/main/writings/pgsql/mvcc.pdf
you can find this talk also on youtube. It's worth watching.
Torsten
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general