Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-08 Thread Vivek Khera
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: MTO> Yeah, FreeBSD testing would have been nice, but I don't have access to MTO> any FreeBSD boxes so. FWIW, with the fflush() added after that sleep, and the fix to the long long computation of sleep time to keep it from overflowi

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-07 Thread Matthew T. O'Connor
Christopher Browne wrote: The world rejoiced as [EMAIL PROTECTED] (Gaetano Mendola) wrote: I think is a good Idea put a fflush after: fprintf(LOGOUTPUT, "[%s] %s\n", timebuffer, logentry); I thought I had put fflush()es at all the interesting locations... I just looked through the code

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-07 Thread Christopher Browne
The world rejoiced as [EMAIL PROTECTED] (Gaetano Mendola) wrote: > I think is a good Idea put a fflush after: > > fprintf(LOGOUTPUT, "[%s] %s\n", timebuffer, logentry); I thought I had put fflush()es at all the interesting locations... Apparently it was an error to not go to the effort of making

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-07 Thread Gaetano Mendola
Gaetano Mendola wrote: Vivek Khera wrote: "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: Then it just sits there. I started it at 11:35am, and it is now 3:30pm. MTO> Weird Alphabetically speaking, is vkmlm."public"."user_list" be the MTO> last table in the last schema in the la

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Vivek Khera
Actually, you can simplify the fix thusly: diff = (long long)(now.tv_sec - then.tv_sec) * 100 + (now.tv_usec - then.tv_usec); ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Vivek Khera
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: MTO> Could this be the recently reported bug where time goes backwards on MTO> FreeBSD? Can anyone who knows more about this problem chime in, I know it MTO> was recently discussed on Hackers. Time does not go backwards -- the now an

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Matthew T. O'Connor
>> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: > > MTO> I don't run FreeBSD, so I haven't tested with FreeBSD. Recently > Craig MTO> Boston reported and submitted a patch for a crash on FreeBSD, > but that > > some more debugging data: > > (gdb) print now > $2 = {tv_sec = 107056507

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Vivek Khera
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: MTO> I don't run FreeBSD, so I haven't tested with FreeBSD. Recently Craig MTO> Boston reported and submitted a patch for a crash on FreeBSD, but that some more debugging data: (gdb) print now $2 = {tv_sec = 1070565077, tv_usec = 216

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Vivek Khera
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: >> I'm running Postgres 7.4 release on FreeBSD 4.9-RELEASE. MTO> I don't run FreeBSD, so I haven't tested with FreeBSD. Recently Craig MTO> Boston reported and submitted a patch for a crash on FreeBSD, but that MTO> doesn't sound like

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Gaetano Mendola
Vivek Khera wrote: "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: Then it just sits there. I started it at 11:35am, and it is now 3:30pm. MTO> Weird Alphabetically speaking, is vkmlm."public"."user_list" be the MTO> last table in the last schema in the last database? You are run

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-04 Thread Vivek Khera
> "MTO" == Matthew T O'Connor <[EMAIL PROTECTED]> writes: >> Then it just sits there. I started it at 11:35am, and it is now >> 3:30pm. MTO> Weird Alphabetically speaking, is vkmlm."public"."user_list" be the MTO> last table in the last schema in the last database? You are running conv

Re: [PERFORM] autovacuum daemon stops doing work after about an hour

2003-12-03 Thread Matthew T. O'Connor
On Tue, 2003-12-02 at 15:37, Vivek Khera wrote: > Now I'm trying to implement pg_autovacuum. It seems to work ok, but > after about an hour or so, it does nothing. The process still is > running, but nothing is sent to the log file. > > I'm running the daemon as distributed with PG 7.4 release a