Re: Allow interrupts on waiting standby

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