Re: low perfomances migrating from 9.3 to 9.5

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: thomas veymont <thomas(dot)veymont(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: low perfomances migrating from 9.3 to 9.5
Date: 2016-07-27 09:06:44
Message-ID: CAB7nPqT3sGnCVVm+yUKyCthH01KmGkg3t0+oUX=s_4=rJubNDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 27, 2016 at 5:54 PM, thomas veymont
<thomas(dot)veymont(at)gmail(dot)com> wrote:
> 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.

Which value are you using for max_wal_size and min_wal_size? And which
value of checkpoint_segments did you use previously? This could
influence the checkpoint frequency.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message thomas veymont 2016-07-27 09:22:56 Re: low perfomances migrating from 9.3 to 9.5
Previous Message thomas veymont 2016-07-27 08:54:22 low perfomances migrating from 9.3 to 9.5