Postgres Pro
Downloads
Home   >   mailing lists

low perfomances migrating from 9.3 to 9.5 - Mailing list pgsql-general

From thomas veymont
Subject low perfomances migrating from 9.3 to 9.5
Date
Msg-id CAHcTkqq13yrVnZ_FW1LCutV_0Zf_ATZtXr9M-uw4JpgdmSZLGw@mail.gmail.com
Whole thread Raw
Responses Re: low perfomances migrating from 9.3 to 9.5  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: Michael Paquier
Date:
Subject: Re: low perfomances migrating from 9.3 to 9.5