Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 3EC3E9FB4D2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 28 Aug 2007 13:36:27 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 30102-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 28 Aug 2007 13:36:22 -0300 (ADT)
X-Greylist: delayed 00:06:01.002252 by SQLgrey-1.7.5
Received: from mu-out-0910.google.com (mu-out-0910.google.com
 [209.85.134.189])
	by postgresql.org (Postfix) with ESMTP id 9BCE79FB3DF
	for <pgsql-performance@postgresql.org>;
	Tue, 28 Aug 2007 13:36:21 -0300 (ADT)
Received: by mu-out-0910.google.com with SMTP id i10so2857036mue
	for <pgsql-performance@postgresql.org>;
	Tue, 28 Aug 2007 09:36:20 -0700 (PDT)
Received: by 10.82.177.3 with SMTP id z3mr1291966bue.1188318619886;
	Tue, 28 Aug 2007 09:30:19 -0700 (PDT)
Received: by 10.82.158.11 with HTTP; Tue, 28 Aug 2007 09:30:19 -0700 (PDT)
Message-ID: <428b865e0708280930h1213b9d4kf18ecb0f3378aeac@mail.gmail.com>
Date: Tue, 28 Aug 2007 11:30:19 -0500
From: "Evan Carroll" <lists@evancarroll.com>
To: pgsql-performance@postgresql.org
Subject: Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Google-Sender-Auth: f95a3d760a3b6d15
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.265 tagged_above=0 required=5 tests=AWL=-0.231,
	BAYES_50=0.001, NO_DNS_FOR_FROM=1.496
X-Spam-Level: *
X-Archive-Number: 200708/358
X-Sequence-Number: 26488

From: "Evan Carroll" <me@evancarroll.com>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>,
pgsql-performance@postgresql.org
Date: Tue, 28 Aug 2007 11:21:54 -0500
Subject: Re: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy)
On 8/28/07, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> >>> On Tue, Aug 28, 2007 at 10:22 AM, in message
> <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com>, "Evan Carroll"
> <lists@evancarroll.com> 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