From: | "Harald Massa" <ghum(at)gmx(dot)net> |
---|---|
To: | "Harald Massa" <ghum(at)gmx(dot)net> |
Cc: | pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | Re: 300 seconds in less than 1 second with pg_autovacuum |
Date: | 2005-01-21 13:02:22 |
Message-ID: | 16277.1106312542@www40.gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
Updating myself: to "300 seconds in less than 1 second"...
I thought of the usual parameter problems, and ....
[2005-01-21 13:56:59 Westeuropäische Normalzeit] INFO: pg_autovacuum
starting in Windows Service mode
[2005-01-21 13:57:21 Westeuropäische Normalzeit] INFO: pg_autovacuum
service stopping...
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: Printing
command_args
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->host=(null)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->port=(null)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->username=postgres
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->password=faghimwyo
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->logfile=c:\ghum\data\pg_log\autovacuum.log
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->install_as_service=0
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->remove_as_service=0
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->service_dependencies=(null)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->service_user=(null)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->service_password=(null)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->sleep_base_value=30000
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->sleep_scaling_factor=2.000000
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->vacuum_base_threshold=1000
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->vacuum_scaling_factor=2.000000
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->analyze_base_threshold=500
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->analyze_scaling_factor=1.000000
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_delay=(default)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_page_hit=(default)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_page_miss=(default)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_page_dirty=(default)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_limit=(default)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: args->debug=3
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: pg_autovacuum
starting in Windows Service mode
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: dbname: template1
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: oid: 1
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: username:
postgres
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: password:
Supersecret...
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: conn is valid,
(connected)
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO: reltuples:
439.000000; relpages: 6
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
curr_analyze_count: 0; curr_vacuum_count: 0
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
last_analyze_count: 0; last_vacuum_count: 0
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
analyze_threshold: 939; vacuum_threshold: 1878
[......]
[2005-01-21 13:57:42 Westeuropäische Normalzeit] INFO:
analyze_threshold: 500; vacuum_threshold: 1000
[2005-01-21 13:57:42 Westeuropäische Normalzeit] DEBUG: 1 All DBs checked
in: 296000 usec, will sleep for 30000 secs.
[2005-01-21 13:58:13 Westeuropäische Normalzeit] DEBUG: 2 All DBs checked
in: 156000 usec, will sleep for 30000 secs.
[2005-01-21 13:58:43 Westeuropäische Normalzeit] DEBUG: updating the
database list
[2005-01-21 13:58:43 Westeuropäische Normalzeit] INFO: dbname: template1
[2005-01-21 13:58:43 Westeuropäische Normalzeit] DEBUG: 3 All DBs checked
in: 281000 usec, will sleep for 30000 secs.
[2005-01-21 13:59:02 Westeuropäische Normalzeit] INFO: pg_autovacuum
service stopping...
Mutliplied the setting with 100 ... and, indeed, every 30.000 milliseconds
(which is 30 seconds) pg_autovacuum runs.
So, I guess, the sleep() function pg_autovacuum is using takes milliseconds
and not seconds as parameters on win32.
Please change documentation or better patch pg_autovacuum (milliseconds is
WAY TO FINE as a resolution for pg_autovacuum sleeping time)
Harald
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-01-21 13:20:06 | Re: 300 seconds in less than 1 second with pg_autovacuum |
Previous Message | Harald Massa | 2005-01-21 12:54:56 | 300 seconds in less than 1 second with pg_autovacuum |