9.1 vs 8.4 performance

Поиск
Список
Период
Сортировка
От salah jubeh
Тема 9.1 vs 8.4 performance
Дата
Msg-id 1348237975.21356.YahooMailNeo@web122201.mail.ne1.yahoo.com
обсуждение исходный текст
Ответы Re: 9.1 vs 8.4 performance  (Jeff Janes <jeff.janes@gmail.com>)
Re: 9.1 vs 8.4 performance  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: 9.1 vs 8.4 performance  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Expression to construct a anonymous record with named columns?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Using psql -f to load a UTF8 file