Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time
Дата
Msg-id 201101150018.52133.achill@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
Στις Friday 14 January 2011 23:20:25 ο/η Kevin Grittner έγραψε:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>
> > What i am asking is ways to understand what is going on, and what
> > to expect when i will have to actually perform the production
> > upgrade to 9.0.2
>
> Sorry to have focused on the wrong issues from your latest post.
> Here's what I suggest to try to get you the best information.
>
> (1)  Abandon this thread, start a new one on the performance list
> with a different subject line.

I agree about the subject line. But whouldn't -bugs be a more apropriate place than -performance?
Pre 8.3 (e.g. 7.4), EXISTS used to run faster than IN, this was fixed in 8.3 (which was IMO a milestone in postgresql
performance), 
should not that be the case with 9.0 as well?

>
>
> -Kevin
>



--
Achilleas Mantzios

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

Предыдущее
От: Fabricio
Дата:
Сообщение: PostgreSQL 9.0.2. This is a Bug?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time