From: Richard Huxton <dev@archonet.com>
To: vincent.moreau@leroymerlin.fr
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Date: Tue, 13 Mar 2007 13:28:47 +0000
Message-ID: <45F6A70F.6050008@archonet.com> (raw)
In-Reply-To: <45F698F4.8030601@leroymerlin.fr>
References: <45F65EA3.1030706@leroymerlin.fr>
<20070313101117.GA98241@winnie.fuhr.org>
<45F686FA.2090909@leroymerlin.fr>
<45F68A73.3070104@archonet.com>
<45F698F4.8030601@leroymerlin.fr>
vincent.moreau@leroymerlin.fr wrote:
> Thanks for the update.
>
> The following did not change anything in the execution plan
>
> ALTER TABLE lm05_t_tarif_panneau ALTER COLUMN lrg_min SET STATISTICS 1000
> ALTER TABLE lm05_t_tarif_panneau ALTER COLUMN lrg_max SET STATISTICS 1000
> ANALYZE lm05_t_tarif_panneau
Hmm - so it's not the distribution of those values.
> I was able to improve response time by creating indexes, but I would
> like to avoid changing the database structure because it is not
> maintained by ourseleves, but by the third party vendor.
Well, the indexes can't do any harm, but it would be nice not to need them.
Could you post the explain analyse with the indexes? To see how the
costs compare.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, 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: <45F6A70F.6050008@archonet.com>
* 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