Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: pg_autovacuum does not start on system
- From: "Matthew T. O'Connor" <matthew(at)tocr(dot)com>
- To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
- Cc: Harald Massa <ghum(at)gmx(dot)net>, pgsql-hackers-win32(at)postgresql(dot)org
- Subject: Re: pg_autovacuum does not start on system
- Date: Mon, 24 Jan 2005 12:31:37 -0500
- Message-id: <41F530F9.2020205@tocr.com> <text/plain>
Dave Page wrote:
The problem with that is that with service start taking 3 minutes, restarting the service manually could be somewhat annoying for simple config changes (bear in mind that the service doesn't report that it is running until it has connected successfully to the database). What about a command line option to specify a delay? That way the user will know about it because they will have specified it?
One answer might be to have pg_autovacuum not be so pessimistic failed connections. I wrote it so that pg_autovacuum exits if it fails to connect. Perhaps instead, when pg_autovacuum fails to connect it should sleep for a while and then retry. Perhaps the best plan would be a new command line option that when used tells pg_autovacuum to continue to retry for ever, when not used, it will still work the way it always did.
Matthew
- References:
- Prev by Date: Re: pg_autovacuum does not start on system startup - 8.0 Release -
- Next by Date: Re: long sql "in" clause crashes server process (8.0 Release)
- Previous by thread: Re: pg_autovacuum does not start on system startup - 8.0 Release -
- Next by thread: Re: pg_autovacuum does not start on system startup - 8.0 Release -
- Indexes: