Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 782629FA2BC for ; Tue, 28 Aug 2007 12:32:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 53469-04-3 for ; Tue, 28 Aug 2007 12:32:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.225]) by postgresql.org (Postfix) with ESMTP id A45B09FA2E6 for ; Tue, 28 Aug 2007 12:32:03 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1248939nzf for ; Tue, 28 Aug 2007 08:32:02 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Tkek+RMHMF+xLpzH9Zyb7EAZBtHILcaGvTb5gkdTtlADBMM6w9QQCGbDd9dRICtVPg/j8/ckqRAc6AYjHaM+dkYuiVNTwDSnIcRdlkDeiHF4E/rK1ZLj0Ik7rgeR+DftCCoCJuKkUCgKFLAf9XwFC3nWOUgO3kZAGWyA4gYIEJs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=qeOuKlRBePP3q8vQeP9nKEWFcZTnRsVql1BGurTeYQao0VVuC2mGQXkCmw202m3g6dd6Hp799PAPHK5XmINHuFG3y+JSvZYnKl4HBGR7V8LbzOaLVVQ23dbLm+aN2RvGCJw3O1I7fVq5rohRavNjp8Ro62S2UGVwIsJBfPdODMc= Received: by 10.141.34.12 with SMTP id m12mr3433843rvj.1188315121839; Tue, 28 Aug 2007 08:32:01 -0700 (PDT) Received: by 10.141.159.11 with HTTP; Tue, 28 Aug 2007 08:32:01 -0700 (PDT) Message-ID: Date: Tue, 28 Aug 2007 10:32:01 -0500 From: "Scott Marlowe" To: "Evan Carroll" Subject: Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Cc: pgsql-performance@postgresql.org In-Reply-To: <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/353 X-Sequence-Number: 26483 On 8/28/07, Evan Carroll wrote: > the midst of a bad day, I decided to make it worse, and upgrade Pg 8.1 > to 8.2. Most people I talk to seem to think 8.1 was a lemon release; > not I. 8.0 was the release that had more issues for me, as it was the first version with all the backend work done to make it capable of running windows. for that reason I stayed on 7.4 until 8.1.4 or so was out. 8.2 was a nice incremental upgrade, and I migrated to it around 8.2.3 and have been happy every since. > Yes, I ran vacuum full after loading both dbs. Did you run analyze? It's not built into vacuum.