Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3CB739F9F39 for ; Tue, 28 Aug 2007 13:28:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 57437-02 for ; Tue, 28 Aug 2007 13:28:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.184]) by postgresql.org (Postfix) with ESMTP id D008B9F9EC6 for ; Tue, 28 Aug 2007 13:28:43 -0300 (ADT) Received: by fk-out-0910.google.com with SMTP id b27so1907890fka for ; Tue, 28 Aug 2007 09:28:42 -0700 (PDT) Received: by 10.82.156.12 with SMTP id d12mr17038592bue.1188318114168; Tue, 28 Aug 2007 09:21:54 -0700 (PDT) Received: by 10.82.158.11 with HTTP; Tue, 28 Aug 2007 09:21:54 -0700 (PDT) Message-ID: <428b865e0708280921n646add4et82a8740c23357fe@mail.gmail.com> Date: Tue, 28 Aug 2007 11:21:54 -0500 From: "Evan Carroll" To: "Kevin Grittner" , pgsql-performance@postgresql.org Subject: Re: 8.2 Query 10 times slower than 8.1 (view-heavy) In-Reply-To: <46D404F9.EE98.0025.0@wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com> <46D404F9.EE98.0025.0@wicourts.gov> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.311 tagged_above=0 required=5 tests=BAYES_40=-0.185, NO_DNS_FOR_FROM=1.496 X-Spam-Level: * X-Archive-Number: 200708/376 X-Sequence-Number: 26506 On 8/28/07, Kevin Grittner wrote: > >>> On Tue, Aug 28, 2007 at 10:22 AM, in message > <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com>, "Evan Carroll" > wrote: > > Yes, I ran vacuum full after loading both dbs. > > Have you run VACUUM ANALYZE or ANALYZE? VACUUM FULL ANALYZE on both tables, out of habit. > > -Kevin > > > > -- Evan Carroll System Lord of the Internets me@evancarroll.com 832-445-8877