Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 28 Aug 2007 10:32:01 -0500
- Message-id: <dcc563d10708280832u4b0b9abbh1b5053bd1b2a9149@mail.gmail.com> <text/plain>
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.
- References:
- 8.2 Query 10 times slower than 8.1 (view-heavy)
- From: Evan Carroll
- 8.2 Query 10 times slower than 8.1 (view-heavy)
- Prev by Date: 8.2 Query 10 times slower than 8.1 (view-heavy)
- Next by Date: Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
- Previous by thread: 8.2 Query 10 times slower than 8.1 (view-heavy)
- Next by thread: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy)
- Indexes: