Upgrading from 9.2 to 9.3 causes performance degradation

Поиск
Список
Период
Сортировка
От Álvaro Nunes Lemos Melo
Тема Upgrading from 9.2 to 9.3 causes performance degradation
Дата
Msg-id 715384951.305581.1395619083841.JavaMail.zimbra@atua.com.br
обсуждение исходный текст
Ответы Re: Upgrading from 9.2 to 9.3 causes performance degradation  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Upgrading from 9.2 to 9.3 causes performance degradation  (Ray Stell <stellr@vt.edu>)
Re: Upgrading from 9.2 to 9.3 causes performance degradation  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
Re: Upgrading from 9.2 to 9.3 causes performance degradation  (Eduardo Morras <emorrasg@yahoo.es>)
Список pgsql-general
Hi,

Recently, I've been trough a datacenter migration, and in this operation I'd also upgraded my PostgreSQL version from
9.2to 9.3. My new hardware is slightly better than the old one, but the PostgreSQL performance has shown degradation in
thewhole system. 

Trying to figure out what could be happening, I'd installed instances of both versions on both servers, and double
checkedall the configuration parameters on them. The 9.2 version results make sense, there's a minor upgrade in the
performanceon the new server, but 9.3 number are worst than 9.2 on both servers, and surprisingly, worst in the newest
thanin the old one. After some research, I tried to disable transparent hugepages on the new one, but it made no
effect.I used and specific query to benchmark, but as I said before, the whole system is slower. 

Below is my data, and I really hope we can find what is happening, or I'll have to downgrade to 9.2 and wait for 9.4
release.

Old Server:
Ubuntu 10.04.4 LTS
2.6.32-45-generic

New Server:
Debian GNU/Linux 7.3 (wheezy)
3.2.0-4-amd64

Query Execution Times (average time of three executions, in seconds)

+--------+-------+-------+
| Server |  9.2  |  9.3  |
+--------+-------+-------+
| Old    |   129 |   216 |
+--------+-------+-------+
| New    |   118 |   275 |
+--------+-------+-------+

Thanks,


--
Álvaro Nunes Melo    Atua Sistemas de Informação
alvaro@atua.com.br   http://www.atua.com.br
(54) 9976-0106       (54) 3045-4144



В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: plpython timestamp without time zone, showing up as text instead of timestamp
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Upgrading from 9.2 to 9.3 causes performance degradation