Re: Execution variability

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Execution variability
Дата
Msg-id 20070628140806.GD5300@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Execution variability  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Ответы Re: Execution variability
Список pgsql-general
Vincenzo Romano escribió:

> The values are here below. I suppose that the "hashed"
> ones imply a default value.

Correct (widely known as "commented out")

> By the way, it seems that the problem arises with only one query,
> while the other ones behave almost the same all the time.

Let's see the EXPLAIN ANALYZE.  Does it involve the big table?

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"There is evil in the world. There are dark, awful things. Occasionally, we get
a glimpse of them. But there are dark corners; horrors almost impossible to
imagine... even in our worst nightmares." (Van Helsing, Dracula A.D. 1972)

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: AutoVacuum Behaviour Question
Следующее
От: Bruce McAlister
Дата:
Сообщение: Re: AutoVacuum Behaviour Question