| From: | Prabhjot Sheena <prabhjot(dot)sheena(at)rivalwatch(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | serious issue with age(relfrozenxid)::int. |
| Date: | 2014-07-20 07:29:13 |
| Message-ID: | CAOf_bQZtQzONb8=uekRJst+W3htRpD7qrW7E1BmAo0z4Gez40Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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 serious
caesius=# 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2014-07-20 08:05:43 | Re: serious issue with age(relfrozenxid)::int. |
| Previous Message | Adrian Klaver | 2014-07-19 00:58:12 | Re: [GENERAL] Editable Views |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2014-07-20 08:05:43 | Re: serious issue with age(relfrozenxid)::int. |
| Previous Message | maplabs | 2014-07-20 03:38:47 | Rank and Partition |