Re: can't stop autovacuum by HUP'ing the server

<div dir="ltr"><br /><br /><div class="gmail_quote">On Tue, Aug 26, 2008 at 12:10 PM, Alvaro Herrera <span
dir="ltr"><<ahref="mailto:alvherre@commandprompt.com">alvherre@commandprompt.com</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex;
padding-left:1ex;"><div class="Ih2E3d">Dave Cramer wrote:<br /><br /><br /> >
AutoVacuumShmem->av_signal[AutoVacForkFailed]= false;<br /> >                                 pg_usleep(100000L);
           /* 100ms */<br /> ><br /> > SendPostmasterSignal(PMSIGNAL_START_AUTOVAC_WORKER);<br /> >          
                     continue;<br /> ><br /> > Do these signals get cleaned up on a reload ?<br /><br
/></div>Well,not on a reload specifically, but this signal is of prompt<br /> response (i.e. the postmaster acts
immediatelyon it).  See<br /> CheckPostmasterSignal.  Also, note that this code starts a worker, not<br /> the launcher
whichis what you're seeing.<br /><br /></blockquote></div><br />Ok, back to why<br /><br />turns out template0 is the
culprit,why is autovac not vacuuming this ?<br /><br />Dave<br /></div>