From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.2.4 serious slowdown |
Date: | 2008-01-10 16:50:57 |
Message-ID: | fm5ihn$eo2$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I meant I did Vacuum Analyze.
In any case, Aside from the vacuum analyze, I also tested it right after a database restore, so there should be no need for any maintenance features.
Sim
Isak Hansen wrote:
> On 1/10/08, Sim Zacks <sim(at)compulab(dot)co(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2008-01-10 16:53:53 | Re: 8.2.4 serious slowdown |
Previous Message | marcelo Cortez | 2008-01-10 16:47:35 | 8.3beta bug or feature? |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2008-01-10 16:51:04 | Re: Dynamic Partitioning using Segment Visibility Maps |
Previous Message | Scott Marlowe | 2008-01-10 16:40:19 | Re: 8.2.4 serious slowdown |