Re: [GENERAL] Too long startup time after each crash.

2016-12-21 Thread Adrian Klaver
On 12/21/2016 06:53 PM, n...@olansoft.com wrote: 22.12.2016, 06:31, "Adrian Klaver" : Alright looks like it doing the correct thing. Now if I am following you say you see the issue starting with 9.5+. As it so happens that is when checkpoint_segments was replaced with max_wal_size: If yo

Re: [GENERAL] Too long startup time after each crash.

2016-12-21 Thread neos
22.12.2016, 06:31, "Adrian Klaver" : > > Alright looks like it doing the correct thing. > > Now if I am following you say you see the issue starting with 9.5+. As > it so happens that is when checkpoint_segments was replaced with > max_wal_size: Yes, in 9.4 recovery process began instantly(or near

Re: [GENERAL] Too long startup time after each crash.

2016-12-21 Thread Adrian Klaver
On 12/21/2016 04:16 PM, n...@olansoft.com wrote: 22.12.2016, 04:21, "Adrian Klaver" : On 12/21/2016 02:17 PM, n...@olansoft.com wrote: Hi. Perhaps i've sent it to wrong mail-list previously. After the upgrade postgresql had a strange behavior. After the crash, server launch now take a l

Re: [GENERAL] Too long startup time after each crash.

2016-12-21 Thread neos
22.12.2016, 04:21, "Adrian Klaver" : > On 12/21/2016 02:17 PM, n...@olansoft.com wrote: >>  Hi. >> >>  Perhaps i've sent it to wrong mail-list previously. >> >>  After the upgrade postgresql had a strange behavior. After the crash, >> server launch now take a long time, up to 30-40 minutes somet

Re: [GENERAL] Too long startup time after each crash.

2016-12-21 Thread Adrian Klaver
On 12/21/2016 02:17 PM, n...@olansoft.com wrote: Hi. Perhaps i've sent it to wrong mail-list previously. After the upgrade postgresql had a strange behavior. After the crash, server launch now take a long time, up to 30-40 minutes sometimes. When connecting to the server (as well as in the lo