Re: [HACKERS] Question about Restart point and checkpoint_segments

2016-02-18 Thread Benoit Lobréau
Sorry for the noise, I got my answer. 2016-02-16 18:02 GMT+01:00 Benoit Lobréau : > Hello, > > I am using a hot_standby setup on PostgreSQL 9.1 > While I was testing, I found out that only checkpoint_timeout (+ a > checkpoint since the last restart point) could trigger

[HACKERS] Question about Restart point and checkpoint_segments

2016-02-16 Thread Benoit Lobréau
Hello, I am using a hot_standby setup on PostgreSQL 9.1 While I was testing, I found out that only checkpoint_timeout (+ a checkpoint since the last restart point) could trigger a restart point. The code (bgwriter.c) seems to confirm this: /* * Check progress against WAL segments