몇일전 우연히 pg_autovacuum.log 보니, 아래와 같이 에러메세지가
나오고 더이상 진행이 되지 않는것 같습니다.
시스템 시작시 아래 명령이 실행되도록 되어 있습니다.
/postgresql/bin/pg_autovacuum -U postgres -d 2 -L
/postgresql/pg_autovacuum.log -D
기존 postgresql.conf 설정은 아래와 같이 되어 있구요...
#stats_row_level = true
stats_row_level = true 를 허용하라는것 같은데, 기존에는 주석처리
되어 있었는데도 잘 돌아가는듯 했거든요?
왜 갑자기 이런 메세지가 나오는지.. 어떻게 해결을 해줘야
하는지요?
그리고... stats_row_level 을 사용하면, 어느정도의 성능저하가
있는지 궁금합니다.
.
.
.
.
[2005-07-03 23:52:30 KST] DEBUG: 9178 All DBs checked in: 49655
usec, will sleep for 300 secs.
[2005-07-03 23:57:30 KST] DEBUG: updating the database list
[2005-07-03 23:57:30 KST] DEBUG: 9179 All DBs checked in: 67188
usec, will sleep for 300 secs.
[2005-07-04 00:02:30 KST] DEBUG: 9180 All DBs checked in: 53506
usec, will sleep for 300 secs.
[2005-07-04 00:07:30 KST] DEBUG: updating the database list
[2005-07-04 00:07:30 KST] DEBUG: 9181 All DBs checked in: 74375
usec, will sleep for 300 secs.
[2005-07-04 00:12:30 KST] DEBUG: 9182 All DBs checked in: 49567
usec, will sleep for 300 secs.
[2005-07-04 00:17:30 KST] DEBUG: updating the database list
[2005-07-04 00:17:30 KST] DEBUG: 9183 All DBs checked in: 67993
usec, will sleep for 300 secs.
[2005-07-04 00:22:30 KST] ERROR: Failed connection to database
template1 with error: FATAL: the database system is shutting
down
.
[2005-07-04 00:22:30 KST] ERROR: Cannot connect to template1,
exiting.
[2005-09-28 01:44:20 KST] INFO: Printing command_args
[2005-09-28 01:44:20 KST] INFO: args->host=(null)
[2005-09-28 01:44:20 KST] INFO: args->port=(null)
[2005-09-28 01:44:20 KST] INFO:
args->username=postgres
[2005-09-28 01:44:20 KST] INFO: args->password=(null)
[2005-09-28 01:44:20 KST] INFO:
args->logfile=/postgresql/pg_autovacuum.log
[2005-09-28 01:44:20 KST] INFO: args->daemonize=1
[2005-09-28 01:44:20 KST] INFO:
args->sleep_base_value=300
[2005-09-28 01:44:20 KST] INFO:
args->sleep_scaling_factor=2.000000
[2005-09-28 01:44:20 KST] INFO:
args->vacuum_base_threshold=1000
[2005-09-28 01:44:20 KST] INFO:
args->vacuum_scaling_factor=2.000000
[2005-09-28 01:44:20 KST] INFO:
args->analyze_base_threshold=500
[2005-09-28 01:44:20 KST] INFO:
args->analyze_scaling_factor=1.000000
[2005-09-28 01:44:20 KST] INFO:
args->av_vacuum_cost_delay=(default)
[2005-09-28 01:44:20 KST] INFO:
args->av_vacuum_cost_page_hit=(default)
[2005-09-28 01:44:20 KST] INFO:
args->av_vacuum_cost_page_miss=(default)
[2005-09-28 01:44:20 KST] INFO:
args->av_vacuum_cost_page_dirty=(default)
[2005-09-28 01:44:20 KST] INFO:
args->av_vacuum_cost_limit=(default)
[2005-09-28 01:44:20 KST] INFO: args->debug=2
[2005-09-28 01:44:22 KST] INFO: dbname: template1
[2005-09-28 01:44:22 KST] INFO: oid: 1
[2005-09-28 01:44:22 KST] INFO: username: postgres
[2005-09-28 01:44:22 KST] INFO: password: (null)
[2005-09-28 01:44:22 KST] INFO: conn is valid,
(connected)
[2005-09-28 01:44:22 KST] INFO: default_analyze_threshold:
1000
[2005-09-28 01:44:22 KST] INFO: default_vacuum_threshold:
500
[2005-09-28 01:44:22 KST] ERROR: GUC variable stats_row_level
must be enabled.
[2005-09-28 01:44:22 KST] Please fix the problems
and try again.
[2005-10-04 16:35:50 KST] INFO: Printing command_args
[2005-10-04 16:35:50 KST] INFO: args->host=(null)
[2005-10-04 16:35:50 KST] INFO: args->port=(null)
[2005-10-04 16:35:50 KST] INFO:
args->username=postgres
[2005-10-04 16:35:50 KST] INFO: args->password=(null)
[2005-10-04 16:35:50 KST] INFO:
args->logfile=/postgresql/pg_autovacuum.log
[2005-10-04 16:35:50 KST] INFO: args->daemonize=1
[2005-10-04 16:35:50 KST] INFO:
args->sleep_base_value=300
[2005-10-04 16:35:50 KST] INFO:
args->sleep_scaling_factor=2.000000
[2005-10-04 16:35:50 KST] INFO:
args->vacuum_base_threshold=1000
[2005-10-04 16:35:50 KST] INFO:
args->vacuum_scaling_factor=2.000000
[2005-10-04 16:35:50 KST] INFO:
args->analyze_base_threshold=500
[2005-10-04 16:35:50 KST] INFO:
args->analyze_scaling_factor=1.000000
[2005-10-04 16:35:50 KST] INFO:
args->av_vacuum_cost_delay=(default)
[2005-10-04 16:35:50 KST] INFO:
args->av_vacuum_cost_page_hit=(default)
[2005-10-04 16:35:50 KST] INFO:
args->av_vacuum_cost_page_miss=(default)
[2005-10-04 16:35:50 KST] INFO:
args->av_vacuum_cost_page_dirty=(default)
[2005-10-04 16:35:50 KST] INFO:
args->av_vacuum_cost_limit=(default)
[2005-10-04 16:35:50 KST] INFO: args->debug=2
[2005-10-04 16:35:52 KST] INFO: dbname: template1
[2005-10-04 16:35:52 KST] INFO: oid: 1
[2005-10-04 16:35:52 KST] INFO: username: postgres
[2005-10-04 16:35:52 KST] INFO: password: (null)
[2005-10-04 16:35:52 KST] INFO: conn is valid,
(connected)
[2005-10-04 16:35:52 KST] INFO: default_analyze_threshold:
1000
[2005-10-04 16:35:52 KST] INFO: default_vacuum_threshold:
500
[2005-10-04 16:35:52 KST] ERROR: GUC variable stats_row_level
must be enabled.
[2005-10-04 16:35:52 KST] Please fix the problems
and try again
읽어주셔서 감사합니다.
|