Matthew T. O'Connor schrieb:
In the windows service world, is there any reason pg_autovacuum should ever give up? The reason I had it give up was so that it didn't accidently run against a different postgresql instance. I don't think that will happen in the windows service world. I think it should keep trying to do it's job until it's told to exit.
A "never giving up" pg_autovacuum seems a little bit rude to me. It's like the salesman who keeps trying to sell me something I have clearly no use.
Especially if in setting up og_autovacuum sth. goes wrong: wrong user, wrong password. Service keeps running, service keeps using ressources, seems perfectly normal... but: nothing happens. (and if everything looks "perfect", checking the logs is not the first you do, do you?)
So: I think a reasonable compromise is to keep pg_autovacuum trying for some time (maybe 5 minutes as Tom recommended) and after that give up.
Harald
begin:vcard fn:Harald Armin Massa n:Massa;Harald Armin org:GHUM Harald Massa adr;quoted-printable;quoted-printable:;;Reinsburgstra=C3=9Fe 202b;Stuttgart;Baden-W=C3=BCrttemberg;70197;Deutschland email;internet:[EMAIL PROTECTED] title:Chef tel;work:0711/6587982 tel;home:0711/6571322 tel;cell:0173/9409607 x-mozilla-html:FALSE url:http://www.ghum.de version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly