Search Postgresql Archives

Re: The age() of a column?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ron <ronljohnsonjr@xxxxxxxxx> 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 data types                    | Type | Volatility |  Parallel  |  Owner   | Security | Access privileges | Language |                                 Source code                                  |                             Description                 
...
 pg_catalog | age  | integer          | xid                                                      | func | stable     | restricted | postgres | invoker  |                   | internal | xid_age                                                                      | age of a transaction ID, in transactions before current transaction

The only reference I could find in the SGML docs is in the maintenance
chapter.

			regards, tom lane





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux