Why is directory pg_commit_ts empty?

Question

I have installed PostgreSQL 13 and created a new database, a few tables and inserted data on those tables. I used transactions to insert data, but still pg_commit_ts is empty.

what is the function of this directory and why is it empty?

score 1 · Accepted Answer · answered Sep 05 '22 at 07:08

1

The directory is empty because track_commit_timestamp is off. It is used to persist commit timestamps.

answered Sep 05 '22 at 07:08

Laurenz Albe

209,280
17
206
263

Thanks @Laurenz Albe. It also means that postgreSQL doesn't store commit timestamp information with rows/tuples instead relevant xmin and xmax. – Monika Yadav Sep 05 '22 at 08:04
No, timestamps are never stored with tuples. – Laurenz Albe Sep 05 '22 at 08:05

Why is directory pg_commit_ts empty?

1 Answers1