Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
Дата
Msg-id 19327.1325266819@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query performance - normal on 9.0.4, slow from 9.0.5 onwards  (Miguel Silva <miguel.silva@tactis.pt>)
Ответы Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards  (Miguel Silva <miguel.silva@tactis.pt>)
Список pgsql-performance
Miguel Silva <miguel.silva@tactis.pt> writes:
> But with postgresql version 9.0.5 (in version 9.0.4 all was fine), we
> noticed the program was taking longer to start. In fact, in some clients
> that had older hardware, it could take around 20 minutes when it usually
> takes only a few seconds. To make a long story short, the problem was
> traced and narrowed down to a single auto generated query. Here it is:

> "SELECT [ snip ]"

> ... Here are the explain analyzes.

> enable_material ON: http://explain.depesz.com/s/wen
> enable_material OFF: http://explain.depesz.com/s/Zaa

It doesn't really accomplish anything to post anonymized explain output
when you've already shown us the actual query, does it?  Especially when
said query involves only the system catalogs and by no stretch of the
imagination could be thought to contain anything proprietary?

            regards, tom lane

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

Предыдущее
От: Miguel Silva
Дата:
Сообщение: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
Следующее
От: Miguel Silva
Дата:
Сообщение: Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards