From: vincent.moreau@leroymerlin.fr
To: vincent.moreau@leroymerlin.fr, Michael Fuhr <mike@fuhr.org>
To: pgsql-performance@postgresql.org
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Date: Tue, 13 Mar 2007 14:28:24 +0100
Message-ID: <45F6A6F8.9090405@leroymerlin.fr> (raw)
In-Reply-To: <20070313130945.GB4490@alvh.no-ip.org>
References: <45F65EA3.1030706@leroymerlin.fr>
<20070313101117.GA98241@winnie.fuhr.org>
<45F686FA.2090909@leroymerlin.fr>
<20070313130945.GB4490@alvh.no-ip.org>
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'internet ne permettant pas d'assurer l'intégrité de ce message, le contenu de ce message ne représente en aucun cas un engagement de la part de Leroy Merlin.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: vincent.moreau@leroymerlin.fr, mike@fuhr.org
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
In-Reply-To: <45F6A6F8.9090405@leroymerlin.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox