Re: Some problems of recovery conflict wait events

2020-04-02 Thread Masahiko Sawada
On Fri, 3 Apr 2020 at 12:28, Fujii Masao wrote: > > > > On 2020/04/02 16:12, Fujii Masao wrote: > > > > > > On 2020/04/02 15:54, Masahiko Sawada wrote: > >> On Thu, 2 Apr 2020 at 15:34, Fujii Masao > >> wrote: > >>> > >>> > >>> > >>> On 2020/04/02 14:25, Masahiko Sawada wrote: > On Wed, 1 A

Re: Some problems of recovery conflict wait events

2020-04-02 Thread Fujii Masao
On 2020/04/02 16:12, Fujii Masao wrote: On 2020/04/02 15:54, Masahiko Sawada wrote: On Thu, 2 Apr 2020 at 15:34, Fujii Masao wrote: On 2020/04/02 14:25, Masahiko Sawada wrote: On Wed, 1 Apr 2020 at 22:32, Fujii Masao wrote: On 2020/03/30 20:10, Masahiko Sawada wrote: On Fri, 27

Re: Some problems of recovery conflict wait events

2020-04-02 Thread Fujii Masao
On 2020/04/02 15:54, Masahiko Sawada wrote: On Thu, 2 Apr 2020 at 15:34, Fujii Masao wrote: On 2020/04/02 14:25, Masahiko Sawada wrote: On Wed, 1 Apr 2020 at 22:32, Fujii Masao wrote: On 2020/03/30 20:10, Masahiko Sawada wrote: On Fri, 27 Mar 2020 at 17:54, Fujii Masao wrote:

Re: Some problems of recovery conflict wait events

2020-04-01 Thread Masahiko Sawada
On Thu, 2 Apr 2020 at 15:34, Fujii Masao wrote: > > > > On 2020/04/02 14:25, Masahiko Sawada wrote: > > On Wed, 1 Apr 2020 at 22:32, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/30 20:10, Masahiko Sawada wrote: > >>> On Fri, 27 Mar 2020 at 17:54, Fujii Masao > >>> wrote: > >

Re: Some problems of recovery conflict wait events

2020-04-01 Thread Fujii Masao
On 2020/04/02 14:25, Masahiko Sawada wrote: On Wed, 1 Apr 2020 at 22:32, Fujii Masao wrote: On 2020/03/30 20:10, Masahiko Sawada wrote: On Fri, 27 Mar 2020 at 17:54, Fujii Masao wrote: On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote:

Re: Some problems of recovery conflict wait events

2020-04-01 Thread Masahiko Sawada
On Wed, 1 Apr 2020 at 22:32, Fujii Masao wrote: > > > > On 2020/03/30 20:10, Masahiko Sawada wrote: > > On Fri, 27 Mar 2020 at 17:54, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/04 14:31, Masahiko Sawada wrote: > >>> On Wed, 4 Mar 2020 at 13:48, Fujii Masao > >>> wrote: > >

Re: Some problems of recovery conflict wait events

2020-04-01 Thread Fujii Masao
On 2020/03/30 20:10, Masahiko Sawada wrote: On Fri, 27 Mar 2020 at 17:54, Fujii Masao wrote: On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: On 2020/03/04 13:27, Michael Paquier wrote: On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sa

Re: Some problems of recovery conflict wait events

2020-03-30 Thread Masahiko Sawada
On Fri, 27 Mar 2020 at 17:54, Fujii Masao wrote: > > > > On 2020/03/04 14:31, Masahiko Sawada wrote: > > On Wed, 4 Mar 2020 at 13:48, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/04 13:27, Michael Paquier wrote: > >>> On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: > >>

Re: Some problems of recovery conflict wait events

2020-03-27 Thread Fujii Masao
On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: On 2020/03/04 13:27, Michael Paquier wrote: On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: Yeah, so 0001 patch sets existing wait events to recovery conflict resolution. For ins

Re: Some problems of recovery conflict wait events

2020-03-27 Thread Fujii Masao
On 2020/03/27 15:39, Masahiko Sawada wrote: On Fri, 27 Mar 2020 at 10:32, Fujii Masao wrote: On 2020/03/26 14:33, Masahiko Sawada wrote: On Tue, 24 Mar 2020 at 17:04, Fujii Masao wrote: On 2020/03/05 20:16, Fujii Masao wrote: On 2020/03/05 16:58, Masahiko Sawada wrote: On Wed, 4

Re: Some problems of recovery conflict wait events

2020-03-26 Thread Masahiko Sawada
On Fri, 27 Mar 2020 at 10:32, Fujii Masao wrote: > > > > On 2020/03/26 14:33, Masahiko Sawada wrote: > > On Tue, 24 Mar 2020 at 17:04, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/05 20:16, Fujii Masao wrote: > >>> > >>> > >>> On 2020/03/05 16:58, Masahiko Sawada wrote: > On Wed, 4

Re: Some problems of recovery conflict wait events

2020-03-26 Thread Fujii Masao
On 2020/03/26 14:33, Masahiko Sawada wrote: On Tue, 24 Mar 2020 at 17:04, Fujii Masao wrote: On 2020/03/05 20:16, Fujii Masao wrote: On 2020/03/05 16:58, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 15:21, Fujii Masao wrote: On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 M

Re: Some problems of recovery conflict wait events

2020-03-25 Thread Masahiko Sawada
On Tue, 24 Mar 2020 at 17:04, Fujii Masao wrote: > > > > On 2020/03/05 20:16, Fujii Masao wrote: > > > > > > On 2020/03/05 16:58, Masahiko Sawada wrote: > >> On Wed, 4 Mar 2020 at 15:21, Fujii Masao > >> wrote: > >>> > >>> > >>> > >>> On 2020/03/04 14:31, Masahiko Sawada wrote: > On Wed, 4

Re: Some problems of recovery conflict wait events

2020-03-24 Thread Fujii Masao
On 2020/03/05 20:16, Fujii Masao wrote: On 2020/03/05 16:58, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 15:21, Fujii Masao wrote: On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: On 2020/03/04 13:27, Michael Paquier wrote: On Wed, Mar

Re: Some problems of recovery conflict wait events

2020-03-11 Thread Masahiko Sawada
On Wed, 11 Mar 2020 at 16:42, Fujii Masao wrote: > > > > On 2020/03/10 13:54, Masahiko Sawada wrote: > > On Tue, 10 Mar 2020 at 00:57, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/09 14:10, Masahiko Sawada wrote: > >>> On Mon, 9 Mar 2020 at 13:24, Fujii Masao > >>> wrote: > > >>>

Re: Some problems of recovery conflict wait events

2020-03-11 Thread Fujii Masao
On 2020/03/10 13:54, Masahiko Sawada wrote: On Tue, 10 Mar 2020 at 00:57, Fujii Masao wrote: On 2020/03/09 14:10, Masahiko Sawada wrote: On Mon, 9 Mar 2020 at 13:24, Fujii Masao wrote: On 2020/03/08 13:52, Masahiko Sawada wrote: On Thu, 5 Mar 2020 at 20:16, Fujii Masao wrote:

Re: Some problems of recovery conflict wait events

2020-03-09 Thread Masahiko Sawada
On Tue, 10 Mar 2020 at 00:57, Fujii Masao wrote: > > > > On 2020/03/09 14:10, Masahiko Sawada wrote: > > On Mon, 9 Mar 2020 at 13:24, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/08 13:52, Masahiko Sawada wrote: > >>> On Thu, 5 Mar 2020 at 20:16, Fujii Masao > >>> wrote: > >

Re: Some problems of recovery conflict wait events

2020-03-09 Thread Fujii Masao
On 2020/03/09 14:10, Masahiko Sawada wrote: On Mon, 9 Mar 2020 at 13:24, Fujii Masao wrote: On 2020/03/08 13:52, Masahiko Sawada wrote: On Thu, 5 Mar 2020 at 20:16, Fujii Masao wrote: On 2020/03/05 16:58, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 15:21, Fujii Masao wrote: O

Re: Some problems of recovery conflict wait events

2020-03-08 Thread Masahiko Sawada
On Mon, 9 Mar 2020 at 13:24, Fujii Masao wrote: > > > > On 2020/03/08 13:52, Masahiko Sawada wrote: > > On Thu, 5 Mar 2020 at 20:16, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/05 16:58, Masahiko Sawada wrote: > >>> On Wed, 4 Mar 2020 at 15:21, Fujii Masao > >>> wrote: > >

Re: Some problems of recovery conflict wait events

2020-03-08 Thread Fujii Masao
On 2020/03/08 13:52, Masahiko Sawada wrote: On Thu, 5 Mar 2020 at 20:16, Fujii Masao wrote: On 2020/03/05 16:58, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 15:21, Fujii Masao wrote: On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: On

Re: Some problems of recovery conflict wait events

2020-03-07 Thread Masahiko Sawada
On Thu, 5 Mar 2020 at 20:16, Fujii Masao wrote: > > > > On 2020/03/05 16:58, Masahiko Sawada wrote: > > On Wed, 4 Mar 2020 at 15:21, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/04 14:31, Masahiko Sawada wrote: > >>> On Wed, 4 Mar 2020 at 13:48, Fujii Masao > >>> wrote: > >

Re: Some problems of recovery conflict wait events

2020-03-05 Thread Fujii Masao
On 2020/03/05 16:58, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 15:21, Fujii Masao wrote: On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: On 2020/03/04 13:27, Michael Paquier wrote: On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Saw

Re: Some problems of recovery conflict wait events

2020-03-05 Thread Masahiko Sawada
On Wed, 4 Mar 2020 at 15:21, Fujii Masao wrote: > > > > On 2020/03/04 14:31, Masahiko Sawada wrote: > > On Wed, 4 Mar 2020 at 13:48, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/04 13:27, Michael Paquier wrote: > >>> On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: > >>>

Re: Some problems of recovery conflict wait events

2020-03-03 Thread Fujii Masao
On 2020/03/04 14:31, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: On 2020/03/04 13:27, Michael Paquier wrote: On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: Yeah, so 0001 patch sets existing wait events to recovery conflict resolution. For ins

Re: Some problems of recovery conflict wait events

2020-03-03 Thread Masahiko Sawada
On Wed, 4 Mar 2020 at 13:48, Fujii Masao wrote: > > > > On 2020/03/04 13:27, Michael Paquier wrote: > > On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: > >> Yeah, so 0001 patch sets existing wait events to recovery conflict > >> resolution. For instance, it sets (PG_WAIT_LOCK | LO

Re: Some problems of recovery conflict wait events

2020-03-03 Thread Fujii Masao
On 2020/03/04 13:27, Michael Paquier wrote: On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: Yeah, so 0001 patch sets existing wait events to recovery conflict resolution. For instance, it sets (PG_WAIT_LOCK | LOCKTAG_TRANSACTION) to the recovery conflict on a snapshot. 0003 p

Re: Some problems of recovery conflict wait events

2020-03-03 Thread Michael Paquier
On Wed, Mar 04, 2020 at 01:13:19PM +0900, Masahiko Sawada wrote: > Yeah, so 0001 patch sets existing wait events to recovery conflict > resolution. For instance, it sets (PG_WAIT_LOCK | LOCKTAG_TRANSACTION) > to the recovery conflict on a snapshot. 0003 patch improves these wait > events by adding

Re: Some problems of recovery conflict wait events

2020-03-03 Thread Masahiko Sawada
On Wed, 4 Mar 2020 at 11:04, Fujii Masao wrote: > > > > On 2020/02/29 12:36, Masahiko Sawada wrote: > > On Wed, 26 Feb 2020 at 16:19, Masahiko Sawada > > wrote: > >> > >> On Tue, 18 Feb 2020 at 17:58, Masahiko Sawada > >> wrote: > >>> > >>> Hi all, > >>> > >>> When recovery conflicts happen on t

Re: Some problems of recovery conflict wait events

2020-03-03 Thread Fujii Masao
On 2020/02/29 12:36, Masahiko Sawada wrote: On Wed, 26 Feb 2020 at 16:19, Masahiko Sawada wrote: On Tue, 18 Feb 2020 at 17:58, Masahiko Sawada wrote: Hi all, When recovery conflicts happen on the streaming replication standby, the wait event of startup process is null when max_standby_s

Re: Some problems of recovery conflict wait events

2020-02-28 Thread Masahiko Sawada
On Wed, 26 Feb 2020 at 16:19, Masahiko Sawada wrote: > > On Tue, 18 Feb 2020 at 17:58, Masahiko Sawada > wrote: > > > > Hi all, > > > > When recovery conflicts happen on the streaming replication standby, > > the wait event of startup process is null when > > max_standby_streaming_delay = 0 (to b

Re: Some problems of recovery conflict wait events

2020-02-25 Thread Masahiko Sawada
On Tue, 18 Feb 2020 at 17:58, Masahiko Sawada wrote: > > Hi all, > > When recovery conflicts happen on the streaming replication standby, > the wait event of startup process is null when > max_standby_streaming_delay = 0 (to be exact, when the limit time > calculated by max_standby_streaming_delay