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@yahoo.com]
Envoyé : mercredi, 31. mai 2006 15:52
À : Philippe Lang
Cc : pgsql-general@postgresql.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.lang@attiksystem.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