Re: another query optimization question - Mailing list pgsql-performance

From Richard Huxton
Subject Re: another query optimization question
Date
Msg-id 200401302025.24541.dev@archonet.com
Whole thread Raw
In response to Re: another query optimization question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Reece Hart
Date:
Subject: Re: query optimization differs between view and explicit
Next
From: David Teran
Date:
Subject: Re: another query optimization question