Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F24F99FB967 for ; Tue, 13 Mar 2007 11:48:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 43265-02 for ; Tue, 13 Mar 2007 11:48:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from globalrelay.com (mail1.globalrelay.com [204.92.49.200]) by postgresql.org (Postfix) with ESMTP id 1DB039FB8EB for ; Tue, 13 Mar 2007 11:48:43 -0300 (ADT) X-Virus-Scanned: Scanned by GRC-AntiVirus Gateway X-GR-Acctd: YES Received: from [63.226.156.118] (HELO DaveEMachine) by globalrelay.com (CommuniGate Pro SMTP 4.2.3) with ESMTP id 131945706; Tue, 13 Mar 2007 07:48:41 -0700 From: "Dave Dutcher" To: Cc: Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3 Date: Tue, 13 Mar 2007 09:48:41 -0500 Message-ID: <011c01c7657e$b16e77c0$2e00a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6822 thread-index: AcdleUSd6qtl64K0QHiaqv4MrETgAQABQ3Ug X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Importance: Normal In-Reply-To: <45F6AF81.80201@leroymerlin.fr> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200703/225 X-Sequence-Number: 23630 > From: pgsql-performance-owner@postgresql.org=20 > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of=20 > vincent.moreau@leroymerlin.fr > Subject: Re: [PERFORM] Execution plan changed after upgrade=20 > from 7.3.9 to 8.2.3 >=20 >=20 > Increasing the default_statistics_target to 1000 did not help. > It just make the vacuum full analyze to take longer to complete. Just FYI when you change statistics you only need to run ANALYZE, not = VACUUM ANALYZE, and definetly not VACUUM FULL ANALYZE. I don't know what else to suggest for this query since you can't change = the SQL. I would talk to the vendor and ask them to add indexes if you know that helps. Dave