Re: PGSQL 7.4 -> 8.1 migration & performance problem

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Ludwig Isaac Lim" <ludz_lim(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: PGSQL 7.4 -> 8.1 migration & performance problem
Date: 2006-05-31 14:09:10
Message-ID: 6C0CF58A187DA5479245E0830AF84F421D0D48@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ludwig Isaac Lim 2006-05-31 14:12:46 Re: PGSQL 7.4 -> 8.1 migration & performance problem
Previous Message Ludwig Isaac Lim 2006-05-31 13:51:35 Re: PGSQL 7.4 -> 8.1 migration & performance problem