Re: Problem with collector statistic

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with collector statistic
Дата
Msg-id 24358.1198084167@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with collector statistic  (Marco Aurélio V. da Silva <marcoprodata@gmail.com>)
Список pgsql-general
"=?iso-8859-1?Q?Marco_Aur=E9lio_V._da_Silva?=" <marcoprodata@gmail.com> writes:
> Running a query on 2 database-equal, with the same indices, but with
> slightly different data, I have a very different result of performance. In
> one the index is used to make the join, in another it is seqscan.

The fact that one explain includes a Limit step, and the other does not,
says that you are not really issuing the same query in both cases.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Getting char * from timestamp in a composite type
Следующее
От: "Sean Z."
Дата:
Сообщение: Deploy postgres - upgrade strategy