On 1/10/08, Sim Zacks <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
