9.1 vs 8.4 performance - Mailing list pgsql-general

From salah jubeh
Subject 9.1 vs 8.4 performance
Date
Msg-id 1348237975.21356.YahooMailNeo@web122201.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: 9.1 vs 8.4 performance
Re: 9.1 vs 8.4 performance
Re: 9.1 vs 8.4 performance
List pgsql-general
Hello,

I have two postgresql servers 9.1.5 and 8.4.8  running on ubuntu machine, both are fresh installs and both has the same configuration files and databases.

I am running queries sequentially on each machine using a database  dumped from a life server ,  and 9.1 server is much slower than 8.4.

I am wondering what might be the cause for this behaviour?  Does 9.1 requires more attention on setting some parameters ..  ?

Regards


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Expression to construct a anonymous record with named columns?
Next
From: Adrian Klaver
Date:
Subject: Re: Using psql -f to load a UTF8 file