pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Evan Carroll <lists@evancarroll.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
Date: Tue, 28 Aug 2007 10:32:01 -0500
Message-ID: <dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com> (raw)
In-Reply-To: <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com>
References: <428b865e0708280822u522391ecr5366bb5a6647f1aa@mail.gmail.com>

On 8/28/07, Evan Carroll <lists@evancarroll.com> 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.



view thread (12+ messages)  latest in thread

Message-ID: <dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com>
Permalink:  ../dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, lists@evancarroll.com
  Subject: Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
  In-Reply-To: <dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox