<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
Does anyone have a comment on this?<br>
<br>
Thanks,<br>
Sean<br>
<div class="moz-forward-container"><br>
<br>
-------- Original Message --------
<table class="moz-email-headers-table" cellpadding="0"
cellspacing="0" border="0">
<tbody>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Subject:
</th>
<td>question about insert_lock</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Date: </th>
<td>Thu, 17 Jul 2014 13:36:13 -0230</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">From: </th>
<td>Sean Hogan <a class="moz-txt-link-rfc2396E" href="mailto:sean@compusult.net"><sean@compusult.net></a></td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">To: </th>
<td><a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-rfc2396E" href="mailto:pgpool-general@pgpool.net"><pgpool-general@pgpool.net></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
Hi,<br>
<br>
I'm a little confused by the documentation of the insert_lock
configuration property at
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<a moz-do-not-send="true"
href="http://www.pgpool.net/docs/latest/pgpool-en.html">http://www.pgpool.net/docs/latest/pgpool-en.html#replication_mode</a>.
Specifically, I'm trying to determine if the default value (false)
is also the recommended value. I have created the insert_lock
table and currently have insert_lock set to 'on'. Is that the
recommended thing for pgpool-II 3.3.3 in native replication mode
against PostgreSQL 9.2.7?<br>
<br>
(The reason: I'm still seeing sporadic, unexplained node
degeneration, where pgpool-II detects a mismatch in the number of
affected tuples. The applications run fine for a while, sometimes
days, then suddenly it happens. Most often it's an update or
delete on a Quartz table. I'd like to eliminate sequence number
mismatch as a reason for the failure.)<br>
<br>
Thanks,<br>
Sean<br>
<br>
</div>
<br>
</body>
</html>