Re: PGSQL 7.4 -> 8.1 migration & performance problem

["Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>]

Hi,

No, the only change I made in postgresql.conf is in order to have the
postmaster listen on the network, and change the default datestyle, just
like I did with all the other installations.

Philippe

-----Message d'origine-----
De : Ludwig Isaac Lim [mailto:ludz_lim(at)yahoo(dot)com] 
Envoyé : mercredi, 31. mai 2006 16:13
À : Philippe Lang
Cc : pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem


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&#65533;: mercredi, 31. mai 2006 15:52
> &#65533;: 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

Attachment: smime.p7s
Description: S/MIME cryptographic signature