Re: Allow interrupts on waiting standby - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: Allow interrupts on waiting standby
Date
Msg-id 0A3221C70F24FB45833433255569204D1F6BD1B7@G01JPEXMBYT05
Whole thread Raw
In response to Re: [HACKERS] Allow interrupts on waiting standby  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Allow interrupts on waiting standby  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Hi, Michael,


From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Michael Paquier
> What do you think about the updated version attached?

I reviewed this patch.  Here are some comments and questions:


(1) monitoring.sgml
The new row needs to be placed in the "Timeout" group.  The current patch puts the row at the end of IO group.  Please
insertthe new row according to the alphabetical order.
 

In addition, "morerows" attribute of the following line appears to be increased.
        <entry morerows="2"><literal>Timeout</></entry>

By the way, doesn't this wait event belong to IPC wait event type, because the process is waiting for other conflicting
processesto terminate the conflict conditions?  Did you choose Timeout type because max_standby_{archive |
streaming}_delayrelates to this wait?  I'm not confident which is appropriate, but I'm afraid users can associate this
waitwith a timeout.
 


(2) standby.c
Do we need to specify WL_LATCH_SET?  Who can set the latch?  Do the backends who ended the conflict set the latch?


(3) standby.c
+    if (rc & WL_LATCH_SET)
+        ResetLatch(MyLatch);
+
+    /* emergency bailout if postmaster has died */
+    if (rc & WL_POSTMASTER_DEATH)
+        proc_exit(1);

I thought the child processes have to terminate as soon as postmaster vanishes.  So, it would be better for the order
ofthe two if statements above to be reversed.  proc_exit() could be exit(), as some children do in postmaster/*.c.
 



(4) standby.c
The latch is not reset when the wait timed out.  The next WaitLatch() would return immediately.


Regards
Takayuki Tsunakawa



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Partitioned tables and relfilenode
Next
From: Alexander Law
Date:
Subject: [PATCH] Remove trailing spaces