Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.2.4 serious slowdown - Mailing list pgsql-general

From Isak Hansen
Subject Re: 8.2.4 serious slowdown
Date
Msg-id 6b9e1eb20801100754x15e036e8k7d3949171c23cf2a@mail.gmail.com
Whole thread Raw
In response to 8.2.4 serious slowdown  (Sim Zacks <sim@compulab.co.il>)
Responses Re: 8.2.4 serious slowdown
List pgsql-general
Tree view 
On 1/10/08, Sim Zacks <sim@compulab.co.il> wrote:
> I just upgraded my database server from 8.0.1 to 8.2.4
> Most things went very well, but I have a couple of queries that really slowed down with the new server.
> On 8.0.1 the query took less then 3 seconds to complete. On 8.2.4 the same query
> (I vacuumed the database before running the query) takes 60 seconds (10 minutes with Explain Analyze).
>


Did you analyze the 8.2 db? AFAIK a plain vacuum doesn't gather any statistics.


Kind regards,
Isak

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Time stamp issue
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Can I create a TYPE (or DOMAIN) with arguments?