On 1/10/08, Sim Zacks <sim@xxxxxxxxxxxxxx> 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
