Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: pg_autovacuum does not start on system startup - 8.0 Release -


  • From: "Harald Massa" <ghum(at)gmx(dot)net>
  • To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
  • Cc: pgsql-hackers-win32(at)postgresql(dot)org
  • Subject: Re: pg_autovacuum does not start on system startup - 8.0 Release -
  • Date: Mon, 24 Jan 2005 12:02:10 +0100 (MET)
  • Message-id: <13916.1106564530@www5.gmx.net> <text/plain>

Dave,

> > So I would suggest to integrate that sleepy workaround within 
> > pg_autovacuum service. Just let it sleep for 'some time' ... maybe even 
> > configurable before it connects. 
> Uh-huh :-)
> 
> 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?

Yeah, I meant that when writing "configurable" ... that is ment to be a
command line parameter. So maybe the default should be 0 to 3 seconds.
(and the command line switch should expect seconds)

Harald






Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group