<div dir="ltr">If you prefix your query with a comment, then that disables the load balancing and it always goes to the master:<div><br></div><div><a href="http://www.pgpool.net/mantisbt/view.php?id=109">http://www.pgpool.net/mantisbt/view.php?id=109</a><br><div class="gmail_extra"><br></div><div class="gmail_extra"><table class="" cellspacing="1" style="width:1150px;border:1px solid rgb(0,0,0);color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:13.3333330154419px"><tbody><tr class="" style="background-color:rgb(216,216,216)"><td colspan="5" style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10pt;padding:4px">0000109: Query prefixed with any comment (/* ... */) triggers NO LOAD BALANCE mode</td></tr><tr class="" style="background-color:rgb(232,232,232)"></tr></tbody></table><br><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><p style="margin-right:0cm;margin-bottom:1.5pt;margin-left:0cm"><b><span style="font-size:14pt;font-family:Helvetica,sans-serif;color:rgb(68,68,68)">Greg Clough</span></b><b><span style="font-size:14pt;font-family:Helvetica,sans-serif"><u></u><u></u></span></b></p><p style="margin-right:0cm;margin-bottom:1.5pt;margin-left:0cm"><b><span style="font-family:Helvetica,sans-serif;color:rgb(68,68,68)">Contract Database Administrator | CWT Digital</span></b></p><p style="margin-right:0cm;margin-bottom:1.5pt;margin-left:0cm"><b style="line-height:28.5pt"><span style="font-family:Helvetica,sans-serif;color:rgb(68,68,68)">t.</span></b><span style="line-height:28.5pt;font-family:Helvetica,sans-serif;color:rgb(68,68,68)"> 0845 456 0070 <b>w.</b> </span><span style="line-height:28.5pt;font-family:Helvetica,sans-serif"><a href="http://www.cwtdigital.com/" style="color:rgb(17,85,204)" target="_blank"><span style="color:rgb(255,153,0)">cwtdigital.com</span></a></span></p><p style="margin-right:0cm;margin-bottom:1.5pt;margin-left:0cm"><span style="font-size:12pt;font-family:'Times New Roman',serif"></span><span style="font-size:9pt;font-family:Helvetica,sans-serif"><u></u><u></u></span></p><p style="margin-right:0cm;margin-bottom:1.5pt;margin-left:0cm"><img src="http://www.cwtdigital.com/hosted/sig.png"></p><p style="margin-right:0cm;margin-bottom:1.5pt;margin-left:0cm"><br><span style="font-family:Helvetica,sans-serif;color:rgb(68,68,68)">Units A/B, Level 8 North, New England House, <br>New England Street, Brighton, East Sussex, BN1 4GH</span></p><p><a href="https://twitter.com/cwtdigital" style="color:rgb(17,85,204)" target="_blank"><span style="font-family:Arial,sans-serif;text-decoration:none;background-image:initial;background-repeat:initial"><img border="0" width="20" height="20" src="cid:image002.png@01CFC827.D51F6D00" alt="https://ci6.googleusercontent.com/proxy/spbuXLCE_kiYn1CBmHRh6DoZX1WwETayC0rma88wNedREVrYPrjvkpQLcBPeuKfSkfkOpDSkuDvye9g2Ps4-BW4s=s0-d-e1-ft#http://www.cwtdigital.com/hosted/twitter.png"></span></a><span style="font-family:Arial,sans-serif;background-image:initial;background-repeat:initial"> </span><a href="https://www.facebook.com/CWTdigital" style="color:rgb(17,85,204)" target="_blank"><span style="font-family:Arial,sans-serif;text-decoration:none;background-image:initial;background-repeat:initial"><img border="0" width="20" height="20" src="cid:image003.png@01CFC827.D51F6D00" alt="https://ci5.googleusercontent.com/proxy/q4GOyacafkMnvs7TLpy3rOcwVK_uxMoECtqVEVpwmxiLShfkGNOZGisnwu4oHGtcEK_C-TfrLguFshp1VKC-5zZw6g=s0-d-e1-ft#http://www.cwtdigital.com/hosted/facebook.png"></span></a><span style="font-family:Arial,sans-serif;background-image:initial;background-repeat:initial"> </span><a href="https://www.linkedin.com/company/cwt-digital" style="color:rgb(17,85,204)" target="_blank"><span style="font-family:Arial,sans-serif;text-decoration:none;background-image:initial;background-repeat:initial"><img border="0" width="21" height="20" src="cid:image004.png@01CFC827.D51F6D00" alt="https://ci4.googleusercontent.com/proxy/BVh2CnIvbQ_Rp5LFVzt4p72zUvhG3u7ksBMtlWRjbWjXL-DXIFEXXZJCYWMlSd3MshfG4UN0NAuTj1eElX8r5iu2KQ=s0-d-e1-ft#http://www.cwtdigital.com/hosted/linkedin.png"></span></a><span style="font-family:Arial,sans-serif;background-image:initial;background-repeat:initial"> </span><a href="https://plus.google.com/s/CWT%20Digital" style="color:rgb(17,85,204)" target="_blank"><span style="font-family:Arial,sans-serif;text-decoration:none;background-image:initial;background-repeat:initial"><img border="0" width="20" height="20" src="cid:image005.png@01CFC827.D51F6D00" alt="https://ci4.googleusercontent.com/proxy/QJJKpRXCvrkfCat5ycimzE7Lve3Pp9wFZWL5eBF5ELDkpl_gA8UVOc-R2p29DTS5DJmfD-FHGg2cjSf4lEuz2Ts=s0-d-e1-ft#http://www.cwtdigital.com/hosted/google.png"></span></a><span style="font-family:Arial,sans-serif;background-image:initial;background-repeat:initial"> </span><a href="http://instagram.com/cwtdigital" style="color:rgb(17,85,204)" target="_blank"><span style="font-family:Arial,sans-serif;text-decoration:none;background-image:initial;background-repeat:initial"><img border="0" width="20" height="20" src="cid:image006.png@01CFC827.D51F6D00" alt="https://ci4.googleusercontent.com/proxy/X2ddbFYXE1hmnS4LGzoCr-Pl8fpK6yoO9R-jjF3__nbZkbuCmQR2LD3-Ts3deetyHm0L8E-hjyXeRS0YTkcqtNNGkxM=s0-d-e1-ft#http://www.cwtdigital.com/hosted/instagram.png"></span></a><br></p></div></div></div></div></div>
<br><div class="gmail_quote">On 13 June 2015 at 04:00, <span dir="ltr"><<a href="mailto:pgpool-general-request@pgpool.net" target="_blank">pgpool-general-request@pgpool.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Send pgpool-general mailing list submissions to<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.sraoss.jp/mailman/listinfo/pgpool-general</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:pgpool-general-request@pgpool.net">pgpool-general-request@pgpool.net</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:pgpool-general-owner@pgpool.net">pgpool-general-owner@pgpool.net</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of pgpool-general digest..."<br>
<br>Today's Topics:<br>
<br>
1. [pgpool-general: 3800] Load balancing questions (Joe Schaefer)<br>
<br><br>---------- Forwarded message ----------<br>From: Joe Schaefer <<a href="mailto:joesuf4@gmail.com">joesuf4@gmail.com</a>><br>To: <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>Cc: <br>Date: Fri, 12 Jun 2015 15:25:55 -0400<br>Subject: [pgpool-general: 3800] Load balancing questions<br>How does load balancing interact with transactions? We have a gui application that does inserts and updates followed immediately by a select to render the results... How do we ensure those selects always go to the master?<br><br>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div></div>