serious issue with age(relfrozenxid)::int. - Mailing list pgsql-general
| From | Prabhjot Sheena |
|---|---|
| Subject | serious issue with age(relfrozenxid)::int. |
| Date | |
| Msg-id | CAOf_bQZtQzONb8=uekRJst+W3htRpD7qrW7E1BmAo0z4Gez40Q@mail.gmail.com Whole thread Raw |
| Responses |
Re: serious issue with age(relfrozenxid)::int.
(John R Pierce <pierce@hogranch.com>)
Re: serious issue with age(relfrozenxid)::int. (Tom Lane <tgl@sss.pgh.pa.us>) |
| List | pgsql-general |
Hi all
Most of my tables in postgresql database 8.3 is showing up this. Pls suggest me what should be done with this and if this is something really seriouscaesius=# select relname, age(relfrozenxid)::int from pg_class order by 2 desc ;
relname | age
-----------------------------------------------------------------+------------
idx_app_param_app_name | 2147483647
triggered_update_columns | 2147483647
triggers | 2147483647
usage_privileges | 2147483647
view_column_usage | 2147483647
view_routine_usage | 2147483647
view_table_usage | 2147483647
views | 2147483647
data_type_privileges | 2147483647
element_types | 2147483647
schemata | 2147483647
sequences | 2147483647
agoda_site_pkey | 2147483647
pg_toast_351460902_index | 2147483647
pg_toast_1380431671_index | 2147483647
airfare_site_market_4_pkey | 2147483647
airfare_site_market_4_uk1 | 2147483647
rollup_upload_id_seq | 2147483647
pg_toast_1174975817_index | 2147483647
rollup_upload_pkey | 2147483647
pg_toast_1128485971_index | 2147483647
report_subscriptions_id_seq | 2147483647
pk_report_subscriptions | 2147483647
report_subscriptions_unique | 2147483647
pg_toast_1496288301_index | 2147483647
idx_work_unit_1_status_5 | 2147483647
pg_toast_905799698_index | 2147483647
organization_audit_pkey | 2147483647
idx_organization_audit_row_id | 2147483647
idx_organization_audit_user_id | 2147483647
pg_toast_351460980_index | 2147483647
pg_toast_351460986_index | 2147483647
pg_toast_1607259454_index | 2147483647
idx_turing_requests_date_inserted | 2147483647
account_organization_id | 2147483647
idx_tmp_new_output_counts_work_unit_id | 2147483647
ferry_lineitem_pkey | 2147483647
pg_toast_905583507_index | 2147483647
script_override_audit_pkey | 2147483647
idx_script_override_audit_row_id | 2147483647
pg_toast_618155951_index | 2147483647
idx_script_override_audit_user_id | 2147483647
pg_toast_351461018_index | 2147483647
pg_toast_618182134_index | 2147483647
finance_lineitem_pkey | 2147483647
pg_toast_618181998_index | 2147483647
pgsql-general by date: