Re: 8.2 Query 10 times slower than 8.1 (view-heavy)

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Evan Carroll" <lists(at)evancarroll(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
Date: 2007-08-28 15:32:01
Message-ID: dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 8/28/07, Evan Carroll <lists(at)evancarroll(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2007-08-28 15:44:03 Re: FW: was [PERFORM] partitioned table and ORDER BY indexed_field DESC LIMIT 1
Previous Message Evan Carroll 2007-08-28 15:22:11 8.2 Query 10 times slower than 8.1 (view-heavy)