Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3

Поиск
Список
Период
Сортировка
От
Тема Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Дата
Msg-id 45F6A6F8.9090405@leroymerlin.fr
обсуждение исходный текст
Ответ на Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
Here it is :

CCM=# SHOW enable_mergejoin;
enable_mergejoin
------------------
on
(1 row)

CCM=#




Alvaro Herrera wrote:
> vincent.moreau@leroymerlin.fr wrote:
>
>> I have attached the requested information.
>>
>> You will see that the query is quite messy and could be easily improved.
>> Unfortunately, it came from a third party application and we do not have
>> access to the source code.
>>
>
> There are only nested loops and hash joins, while the other plan seems
> to be more elaborate -- I wonder if you have disabled bitmap scan, merge
> joins, in 8.2?   Try a SHOW enable_mergejoin in psql.
>
>


Ce message et toutes les pièces jointes sont établis à l'attention exclusive de leurs destinataires et sont
confidentiels.Si vous recevez ce message par erreur, merci de le détruire et d'en avertir immédiatement l'expéditeur.
L'internetne permettant pas d'assurer l'intégrité de ce message, le contenu de ce message ne représente en aucun cas un
engagementde la part de Leroy Merlin. 


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

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3