Re: 8.2.4 serious slowdown

On 1/10/08, Sim Zacks <sim(at)compulab(dot)co(dot)il> wrote:
> 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.
>

The stats didn't look too far off, no.

Perhaps a suboptimal plan is picked due to configuration issues, e.g.
memory constraints? Could you post your postgresql.conf as well?

Kind regards,
Isak

> 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
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>