Re: [PERFORM] Delay in converting logs from ready state to done state

2016-10-11 Thread Julien Rouhaud
On 12/10/2016 07:26, Samir Magar wrote: > Team, > > we are seeing delay in converting logs from ready state to done state in > pg_xlog archive status. > > we have seen pg_xlog generated 2000 per hour and it is getting archived > 1894. So the speed at which the archiving is done is too slow as com

[PERFORM] Delay in converting logs from ready state to done state

2016-10-11 Thread Samir Magar
Team, we are seeing delay in converting logs from ready state to done state in pg_xlog archive status. we have seen pg_xlog generated 2000 per hour and it is getting archived 1894. So the speed at which the archiving is done is too slow as compare to the pg_xlog generation So our pg_xlog directo

Re: [PERFORM] Why query plan is different?

2016-10-11 Thread Pavel Stehule
2016-10-11 13:19 GMT+02:00 Andrzej Zawadzki : > On 11.10.2016 03:47, Pavel Stehule wrote: > > > > 2016-10-10 23:17 GMT+02:00 Andrzej Zawadzki : > >> On 10.10.2016 17:31, Andrzej Zawadzki wrote: >> >> Hi, >> Today, I noticed strange situation: >> >> The same query run on different servers has very

Re: [PERFORM] Why query plan is different?

2016-10-11 Thread Andrzej Zawadzki
On 11.10.2016 03:47, Pavel Stehule wrote: 2016-10-10 23:17 GMT+02:00 Andrzej Zawadzki : On 10.10.2016 17:31,