The following bug has been logged on the website:
Bug reference: 16009
Logged by: david ni
Email address: zn1314@126.com
PostgreSQL version: 10.4
Operating system: CentOS Linux release 7.3.1611 (Core)
Description:
1,autovaccum is not triggered
relid | 26342
schemaname | hengtian_gb_bj
relname | tu_login
seq_scan | 1
seq_tup_read | 13823
idx_scan | 1347432
idx_tup_fetch | 1347420
n_tup_ins | 12
n_tup_upd | 673710
n_tup_del | 0
n_tup_hot_upd | 672658
n_live_tup | 13831
n_dead_tup | 1634
n_mod_since_analyze | 1322
last_vacuum | 2019-09-10 18:01:56.326208+08
last_autovacuum |
last_analyze | 2019-09-10 18:01:57.632177+08
last_autoanalyze | 2019-09-17 15:26:43.607952+08
vacuum_count | 2
autovacuum_count | 0
analyze_count | 1
autoanalyze_count | 455
hengtian_tsp_prod=# show autovacuum;
-[ RECORD 1 ]--
autovacuum | on
hengtian_tsp_prod=# show autovacuum_vacuum_threshold;
-[ RECORD 1 ]---------------+---
autovacuum_vacuum_threshold | 50
hengtian_tsp_prod=# show autovacuum_vacuum_scale_factor ;
-[ RECORD 1 ]------------------+----
autovacuum_vacuum_scale_factor | 0.2
2,vacuum scheduled.qrtz_locks ;
ERROR: found xmax 1245512970 from before relfrozenxid 1245512975
table can not be vacuumed
3,I want to subscribe the mailing list,go to
https://lists.postgresql.org,click "Manage subscriptions",then returns
"Server Error(500)"