Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-28 Thread thomas veymont
hi Melvin, Adrian, > > Where did you get the respective versions of Postgres? > both were compiled from source, from the official website tar files. gcc is 4.1.2 20080704 (Red Hat 4.1.2-48) > > Where they installed the same way? > yes, exactly the same. My configure command line is:

Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread Melvin Davidson
On Wed, Jul 27, 2016 at 11:01 AM, Adrian Klaver wrote: > On 07/27/2016 07:52 AM, thomas veymont wrote: > >> >> 2016-07-27 14:11 GMT+02:00 Michael Paquier > >: >> >> >> >> >> And do you see changes if you

Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread Adrian Klaver
On 07/27/2016 07:52 AM, thomas veymont wrote: 2016-07-27 14:11 GMT+02:00 Michael Paquier >: And do you see changes if you increase min_wal_size? This will increase the number of WAL segments recycled instead of removed at

Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread thomas veymont
2016-07-27 14:11 GMT+02:00 Michael Paquier : > > > And do you see changes if you increase min_wal_size? This will > increase the number of WAL segments recycled instead of removed at > each checkpoint. > -- > Michael > I have seen no improvment with the following

Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread Michael Paquier
On Wed, Jul 27, 2016 at 6:22 PM, thomas veymont wrote: > as far as I remember these settings were for faster bulk loading. > > in 9.5 we set: > max_wal_size = 6GB # > https://www.postgresql.org/docs/9.5/static/release-9-5.html, max_wal_size = > (3 *

Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread thomas veymont
2016-07-27 11:06 GMT+02:00 Michael Paquier : > On Wed, Jul 27, 2016 at 5:54 PM, thomas veymont > wrote: > > We switched from PostgreSQL server 9.3 to 9.5. From the very beginning > there > > was a noticeable drop in performances (for example :

Re: [GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread Michael Paquier
On Wed, Jul 27, 2016 at 5:54 PM, thomas veymont 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). >

[GENERAL] low perfomances migrating from 9.3 to 9.5

2016-07-27 Thread thomas veymont
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