Friday 31 March 2017

To track last modified commit or get last modified timestamp of table in postgresql

PostgreSQL 9.5 let us to track last modified commit.

1. Check track commit is on or off using the following query

  show track_commit_timestamp;

2. If it return "ON" go to step 3 else modify postgresql.conf