From: | "Isak Hansen" <isak(dot)hansen(at)gmail(dot)com> |
---|---|
To: | "Sim Zacks" <sim(at)compulab(dot)co(dot)il> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.2.4 serious slowdown |
Date: | 2008-01-10 17:56:15 |
Message-ID: | 6b9e1eb20801100956r74983111q47507387de933b26@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo | 2008-01-10 18:06:45 | Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4? |
Previous Message | Andrew Sullivan | 2008-01-10 17:48:53 | Re: Storing and querying boolean fields |
From | Date | Subject | |
---|---|---|---|
Next Message | Sim Zacks | 2008-01-10 18:10:46 | Re: 8.2.4 serious slowdown |
Previous Message | Ron Mayer | 2008-01-10 17:40:05 | Re: Dynamic Partitioning using Segment Visibility Maps |