Re: another query optimization question

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: another query optimization question
Дата
Msg-id 200401302025.24541.dev@archonet.com
обсуждение исходный текст
Ответ на Re: another query optimization question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Reece Hart
Дата:
Сообщение: Re: query optimization differs between view and explicit
Следующее
От: David Teran
Дата:
Сообщение: Re: another query optimization question