On 4 August 2016 at 01:35, Joshua Bay <joshuaba...@gmail.com> wrote: > Thanks for responses! > > The problem I wanted to solve was to find the (global) order of commits > across the postgres cluster. So, my attempt was to use the LSN. >
Have a look at how logical decoding does it. Check out ReorderBufferCommit in src/backend/replication/logical/reorderbuffer.c . Or just write a trivial a logical decoding plugin that only implements the commit callback and only emits the LSN. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services