Re: Time jumping on both 4.x and 5.x ...

2003-11-29 Thread Kris Kennaway
On Sat, Nov 29, 2003 at 07:04:16AM +0100, Michael Nottebrock wrote: Content-Description: signed data On Saturday 29 November 2003 05:57, Dag-Erling Sm?rgrav wrote: Marc G. Fournier [EMAIL PROTECTED] writes: as to ntpd/timed ... don't run either ... run ntpdate twice a day (11:59 and

Re: Time jumping on both 4.x and 5.x ...

2003-11-29 Thread Michael Nottebrock
On Saturday 29 November 2003 09:19, Kris Kennaway wrote: Are all affected machines multi-processor? None. Both are i386 UP (although the 4.9-RELEASE box is running an SMP-enabled kernel). -- ,_, | Michael Nottebrock | [EMAIL PROTECTED] (/^ ^\) | FreeBSD - The Power to

Re: Time jumping on both 4.x and 5.x ...

2003-11-29 Thread Kris Kennaway
On Sat, Nov 29, 2003 at 11:32:28AM +0100, Michael Nottebrock wrote: Content-Description: signed data On Saturday 29 November 2003 09:19, Kris Kennaway wrote: Are all affected machines multi-processor? None. Both are i386 UP (although the 4.9-RELEASE box is running an SMP-enabled kernel).

Re: Time jumping on both 4.x and 5.x ...

2003-11-29 Thread Michael Nottebrock
On Saturday 29 November 2003 11:43, Kris Kennaway wrote: I didn't think 4.x SMP kernels could run on a UP machine. It's a pretty decent Pentium4 Mobo, I guess it meets the requirements for an SMP-Board running one CPU. From dmesg: Timecounter i8254 frequency 1193182 Hz CPU: Intel(R)

RE: Time jumping on both 4.x and 5.x ...

2003-11-29 Thread Don Bowman
From: Kris Kennaway [mailto:[EMAIL PROTECTED] On Sat, Nov 29, 2003 at 11:32:28AM +0100, Michael Nottebrock wrote: Content-Description: signed data On Saturday 29 November 2003 09:19, Kris Kennaway wrote: Are all affected machines multi-processor? None. Both are i386 UP (although

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Mathew Kanner
On Nov 28, Marc G. Fournier wrote: In trying to isolate an issue where the PostgreSQL 'explain analyze' is showing odd results (namely, negative time estimates on queries), Tom Lane wrote a quick C program to test gettimeofday() (program attached) ... the results on a 4.9-PRERELEASE kernel

Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Marc G. Fournier
In trying to isolate an issue where the PostgreSQL 'explain analyze' is showing odd results (namely, negative time estimates on queries), Tom Lane wrote a quick C program to test gettimeofday() (program attached) ... the results on a 4.9-PRERELEASE kernel of Sep 20 14:16:48 ADT 2003 shows:

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Kris Kennaway
On Fri, Nov 28, 2003 at 09:32:30PM -0400, Marc G. Fournier wrote: In trying to isolate an issue where the PostgreSQL 'explain analyze' is showing odd results (namely, negative time estimates on queries), Tom Lane wrote a quick C program to test gettimeofday() (program attached) ... the

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Marc G. Fournier
On Fri, 28 Nov 2003, Kris Kennaway wrote: On Fri, Nov 28, 2003 at 09:32:30PM -0400, Marc G. Fournier wrote: In trying to isolate an issue where the PostgreSQL 'explain analyze' is showing odd results (namely, negative time estimates on queries), Tom Lane wrote a quick C program to test

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread YONETANI Tomokazu
Hello. On Sat, Nov 29, 2003 at 12:36:22AM -0400, Marc G. Fournier wrote: What hardware, kernel configuration, etc? Do you have a misconfigured ntpd/timed that is manually flapping the time around? Hardware for the above is a Dual-Xeon, 4Gig of RAM, and about 421 processes running on it

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Dag-Erling Smørgrav
Marc G. Fournier [EMAIL PROTECTED] writes: as to ntpd/timed ... don't run either ... run ntpdate twice a day (11:59 and 23:59) Don't Do That. It will lead to all kinds of trouble that will take you ages to figure out. Really, ntpd is so ridiculously easy to set up (especially if you already

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Kris Kennaway
On Sat, Nov 29, 2003 at 12:36:22AM -0400, Marc G. Fournier wrote: Hardware for the above is a Dual-Xeon, 4Gig of RAM, and about 421 processes running on it currently ... kernel config is at the bottom, but I don't think there is anything 'abnormal' about it ... and note that I've had others

Re: Time jumping on both 4.x and 5.x ...

2003-11-28 Thread Michael Nottebrock
On Saturday 29 November 2003 05:57, Dag-Erling Smørgrav wrote: Marc G. Fournier [EMAIL PROTECTED] writes: as to ntpd/timed ... don't run either ... run ntpdate twice a day (11:59 and 23:59) Don't Do That. It will lead to all kinds of trouble that will take you ages to figure out. Really,