From: | Ludwig Isaac Lim <ludz_lim(at)yahoo(dot)com> |
---|---|
To: | Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PGSQL 7.4 -> 8.1 migration & performance problem |
Date: | 2006-05-31 14:12:46 |
Message-ID: | 20060531141246.69760.qmail@web32911.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
How about the postgresql.conf settings? Did you changed
them?
ludwig.
--- Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> wrote:
> Hi,
>
> I did not mention it in my first email, but I did run
> "ANALYSE" before
> running the query... So statistics are just fine for the
> execution plan
> engine.
>
> Philippe
>
> -----Message d'origine-----
> De : Ludwig Isaac Lim [mailto:ludz_lim(at)yahoo(dot)com]
> Envoy�: mercredi, 31. mai 2006 15:52
> �: Philippe Lang
> Cc : pgsql-general(at)postgresql(dot)org
> Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration &
> performance problem
>
> Hi :
>
> Maybe you forget to run the "ANALYZE" command
> afterwards.
>
> ludwig.
>
> --- Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> wrote:
>
> > Hi,
> >
> > For an unknown reason, I cannot post this message to
> the mailing-list!
> >
> > Here it is:
> >
> > http://www.attiksystem.ch/postgresql-general.txt
> >
> > Cheers,
> >
> > Philippe Lang
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Greg | 2006-05-31 14:13:05 | Synchronizing tables |
Previous Message | Philippe Lang | 2006-05-31 14:09:10 | Re: PGSQL 7.4 -> 8.1 migration & performance problem |