On Friday 30 January 2004 19:19, Tom Lane wrote: > > The hash-join total time is obviously wrong seeing that the total > runtime is only about 100000 msec, and the negative values for the other > two are even more obviously wrong. > > I recall that we saw similar symptoms once before, and I thought we'd > fixed it, but I didn't find any relevant mentions in the CVS logs.
You're not thinking of the -ve durations on the auto-vacuum gizmo? Something to do with system clock accuracy IIRC. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org