[ADMIN] Repeating autovacuum

Поиск
Список
Период
Сортировка
От Ertan Küçükoğlu
Тема [ADMIN] Repeating autovacuum
Дата
Msg-id 009201d2afef$3e9432f0$bbbc98d0$@1nar.com.tr
обсуждение исходный текст
Ответы Re: [ADMIN] Repeating autovacuum  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Hello,

I have a PostgreSQL 9.6.2 running on Windows 10 EnterpriseDB binaries. This
is a software development desktop computer having i7 entry level CPU and
Sandisk Extreme SSD and 8GB RAM.

While trying to figure some login related stuff, I realize that autovacuum
is repeating non-stop. Below is about 15-20 minute debug2 level log entries
after restarting the server.

I have 2 databases which have only table definitions in them. Only one of
them named "tracker" have about 15 records in it. Basically they are empty.

Memory related parameters in my config file are not modified, just removed
remarks on below items:
shared_buffers = 128M
work_mem = 4MB
maintenance_work_mem = 64MB
autovacuum_work_mem = -1

No autovacuum parameters are changed or used. They are all remarked as in
default config file.

I wonder if that is a normal behavior as system is idle.
-----
LOG:  database system was shut down at 2017-04-08 01:04:50 +03
DEBUG:  checkpoint record is at 0/17662D8
DEBUG:  redo record is at 0/17662D8; shutdown TRUE
DEBUG:  next transaction ID: 0:697; next OID: 16888
DEBUG:  next MultiXactId: 1; next MultiXactOffset: 0
DEBUG:  oldest unfrozen transaction ID: 536, in database 12401
DEBUG:  oldest MultiXactId: 1, in database 16526
DEBUG:  commit timestamp Xid oldest/newest: 0/0
DEBUG:  transaction ID wrap limit is 2147484183, limited by database with
OID 12401
DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID
16526
DEBUG:  starting up replication slots
DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID
16526
LOG:  MultiXact member wraparound protections are now enabled
DEBUG:  MultiXact member stop limit is now 4294914944 based on MultiXact 1
LOG:  database system is ready to accept connections
DEBUG:  checkpointer updated shared memory configuration values
LOG:  autovacuum launcher started
DEBUG:  removing permanent stats file "pg_stat/db_12401.stat"
DEBUG:  removing permanent stats file "pg_stat/db_1.stat"
DEBUG:  removing permanent stats file "pg_stat/db_16526.stat"
DEBUG:  removing permanent stats file "pg_stat/db_16461.stat"
DEBUG:  removing permanent stats file "pg_stat/db_0.stat"
DEBUG:  removing permanent stats file "pg_stat/global.stat"
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  forked new backend, pid=8716 socket=5016
LOG:  connection received: host=::1 port=60268
LOG:  connection authorized: user=DESKTOP-L63HSP2$ database=postgres
DEBUG:  server process (PID 8716) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "tracker"
DEBUG:  received inquiry for database 16526
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_16526.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 14664) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "spanc"
DEBUG:  received inquiry for database 16461
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_16461.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 16176) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "template1"
DEBUG:  received inquiry for database 1
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_1.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 16220) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "postgres"
DEBUG:  received inquiry for database 12401
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_12401.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 8568) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "tracker"
DEBUG:  received inquiry for database 16526
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_16526.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 16156) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "spanc"
DEBUG:  received inquiry for database 16461
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_16461.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 14892) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "template1"
DEBUG:  received inquiry for database 1
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_1.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 17756) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "postgres"
DEBUG:  received inquiry for database 12401
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_12401.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 18316) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "tracker"
DEBUG:  received inquiry for database 16526
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_16526.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 14204) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "spanc"
DEBUG:  received inquiry for database 16461
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_16461.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 5668) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "template1"
DEBUG:  received inquiry for database 1
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_1.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 15884) exited with exit code 0
DEBUG:  received inquiry for database 0
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  autovacuum: processing database "postgres"
DEBUG:  received inquiry for database 12401
DEBUG:  writing stats file "pg_stat_tmp/global.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_12401.stat"
DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
DEBUG:  server process (PID 5188) exited with exit code 0
-----





В списке pgsql-admin по дате отправления:

Предыдущее
От: "michael@sqlexec.com"
Дата:
Сообщение: Re: [ADMIN] How do you manage cluster replication and failover ?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] Repeating autovacuum