Re: optimization downgrade perfomance?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: optimization downgrade perfomance?
Дата
Msg-id 3192.1127482808@sss.pgh.pa.us
обсуждение исходный текст
Ответ на optimization downgrade perfomance?  (eVl <evl.evl@gmail.com>)
Список pgsql-performance
eVl <evl.evl@gmail.com> writes:
>     When executing this SELECT (see SELECT.A above) it executes in about 700 ms, but when I want wipe out all info
aboutlocal traffic, with query like this: 
>       SELECT * FROM ( SELECT.A ) a WHERE type = 'global';
> It executes about 10000 ms - more then 10 TIMES SLOWER!

>  Why this could be?

You tell us --- let's see EXPLAIN ANALYZE results for both cases.

            regards, tom lane

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

Предыдущее
От: Joost Kraaijeveld
Дата:
Сообщение: Re: How to determine cause of performance problem?
Следующее
От: Joost Kraaijeveld
Дата:
Сообщение: Re: How to determine cause of performance problem?