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

2003-12-07 Thread Bruce Momjian
This has been fixed and will be in 7.4.1. --- Vivek Khera wrote: > > "LR" == Larry Rosenman <[EMAIL PROTECTED]> writes: > > >> I'd be curious to see the output of this program on other platforms > >> and other compilers

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

2003-12-04 Thread Vivek Khera
> "LR" == Larry Rosenman <[EMAIL PROTECTED]> writes: >> I'd be curious to see the output of this program on other platforms >> and other compilers. I'm using gcc 2.95.4 as shipped with FreeBSD >> 4.8+. LR> this is with the UnixWare compiler: LR> $ cc -O -o testvk testvk.c LR> $ ./testvk LR> s

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

2003-12-04 Thread Larry Rosenman
--On Thursday, December 04, 2003 16:20:22 -0500 Vivek Khera <[EMAIL PROTECTED]> wrote: "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 i

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