Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 186759FB612 for ; Tue, 13 Mar 2007 10:32:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 43469-01 for ; Tue, 13 Mar 2007 10:32:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 335EB9FB636 for ; Tue, 13 Mar 2007 10:32:09 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 5A5F2761D3; Tue, 13 Mar 2007 13:28:47 +0000 (GMT) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 355DD274093; Tue, 13 Mar 2007 13:28:47 +0000 (GMT) Message-ID: <45F6A70F.6050008@archonet.com> Date: Tue, 13 Mar 2007 13:28:47 +0000 From: Richard Huxton User-Agent: IceDove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: vincent.moreau@leroymerlin.fr Cc: Michael Fuhr , pgsql-performance@postgresql.org Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3 References: <45F65EA3.1030706@leroymerlin.fr> <20070313101117.GA98241@winnie.fuhr.org> <45F686FA.2090909@leroymerlin.fr> <45F68A73.3070104@archonet.com> <45F698F4.8030601@leroymerlin.fr> In-Reply-To: <45F698F4.8030601@leroymerlin.fr> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.097 tagged_above=0 required=5 tests=AWL, BAYES_40, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/221 X-Sequence-Number: 23626 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