Re: The age() of a column?

2018-11-28 Thread Adrian Klaver
On 11/28/18 7:32 PM, Ron wrote: What does it mean, and where is it documented?  The only place in the https://www.postgresql.org/docs/10/routine-vacuuming.html "The age column measures the number of transactions from the cutoff XID to the current transaction's XID." docs I see reference to

Re: The age() of a column?

2018-11-28 Thread Tom Lane
Ron writes: > What does it mean, and where is it documented? age(xid) returns the difference between the given xid and the current xid. It's not terribly well documented, but psql's \df gives some info: regression=# \df+ age Schema | Name | Result data type | Argument dat

The age() of a column?

2018-11-28 Thread Ron
What does it mean, and where is it documented?  The only place in the docs I see reference to age() is https://www.postgresql.org/docs/9.6/functions-datetime.html and this doesn't seem to fit that use case. Thanks TAPb=# select COALESCE(ta.schemaname, 'pg_toast') || '.' || cl.relname,