[GENERAL] low perfomances migrating from 9.3 to 9.5

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

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

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 : when injecting our > SQL

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

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 parameters in 9.5: max_wal_size =

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

it's machine/OS dependant or even I am doing my test the wrong way. I will be back to you with more objective values by next week. thanks for helping, Tom 2016-07-27 17:14 GMT+02:00 Melvin Davidson : > > > On Wed, Jul 27, 2016 at 11:01 AM, Adrian Klaver > wrote: &

[GENERAL] gaps/overlaps in a time table : current and previous row question

hello, let's say that each rows in a table contains a start time and a end time ("timeinterval" type), but the index are not ordered nor consecutive, e.g : $ select * from T order by starttime index | starttime| endtime -+-+- 3| t1

Re: [GENERAL] gaps/overlaps in a time table : current and previous row question

2011/10/6 : >> -Original Message- >> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] On Behalf Of thomas veymont >> Sent: Wednesday, October 05, 2011 5:35 PM >> To: pgsql-general@postgresql.org >> Subject: [GE