serious issue with age(relfrozenxid)::int.

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

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux