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

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

2003-12-02 Thread Vivek Khera
I took advantage of last weekend to upgrade from 7.2.4 to 7.4.0 on a new faster box. 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 distr