low perfomances migrating from 9.3 to 9.5

Поиск
Список
Период
Сортировка
От thomas veymont
Тема low perfomances migrating from 9.3 to 9.5
Дата
Msg-id CAHcTkqq13yrVnZ_FW1LCutV_0Zf_ATZtXr9M-uw4JpgdmSZLGw@mail.gmail.com
обсуждение исходный текст
Ответы Re: low perfomances migrating from 9.3 to 9.5  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
hello all,

We switched from PostgreSQL server 9.3 to 9.5. From the very beginning there was a noticeable drop in performances (for example : when injecting our SQL dumps into 9.5, COPY and CREATE INDEX were very slow).

Our configuration file was the same for 9.3 and 9.5, except for the "chekpoint segment" that has been deprecated.

I haven't got (yet) some objective performance measurements to show, because the problem was so obvious (just by looking at the log feed) that we switched back quickly to 9.3 (production constraints).

What could be the reason for such a problem ?
I thought that, maybe, our system kernel is getting obsolete for a recent postgresql engine ?
OS is Centos 5.5 kernel 2.6.18-194.el5 #1 SMP x86_64

thanks for suggestions,
Tom

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Uber migrated from Postgres to MySQL
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: low perfomances migrating from 9.3 to 9.5