<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Would you try a test with pgbench?<br><br>Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">> On 06/01/2012 01:44 AM, Tatsuo Ishii wrote:<br>>>> I am trying to load balance with pgpool (3.1.1-1) over two DB nodes<br>>>> (PostgreSQL 9.0): 1 master & 1 slave, configured for streaming replication.<br>>>><br>>>> The thing is that all the queries are going to the master node. I<br>>>> created a simple shell script in order to simulate dozens of connections<br>>>> querying simultaneously in a loop, then disconnecting, connecting again,<br>>>> querying, etc., but there's no query sent to the slave node at all.<br>>>><br>>>> At the same time, when browsing through pgpoolAdmin, queries like<br>>>> "SELECT pg_is_in_recovery()", and "SELECT * FROM pg_settings" are<br>>>> arriving successfully on both places, so there's no connection issue<br>>>> involved.<br>>>><br>>>> I have even set the weight to 0 for the master:<br>>>><br>>>> backend_weight0 = 0<br>>>> backend_weight1 = 1<br>>>><br>>>> But still, every query is sent there and not on the slave.<br>>>><br>>>> Any thoughts why load balancing is not working in that case?<br>>> For SELECT pg_is_in_recovery() itself, there's no reason not to load<br>>> balance. Maybe delay_threshold?<br>>><br>>> For SELECT * FROM pg_settings, it is not load balanced since it is<br>>> accessing system catalog.<br>> <br>> In my case delay_threshold = 0, so it is disabled.<br>> <br>> What I meant was that those two queries appear in the PostgreSQL logs of<br>> both servers - the master and the slave, which is an indication that<br>> pgpool is connected to both.<br>> <br>> However, when issuing simple SELECT query, it appears in the log of the<br>> master only. It is not load balanced. I am running the following script<br>> from 20 terminals in parallel:<br>> <br>> #!/bin/bash<br>> for a in `seq 1 10`; do<br>> echo -n "$a: "<br>> for usr in `psql -U postgres -d test -h localhost -p 5433 -t -c<br>> "SELECT id FROM test ORDER BY RANDOM() LIMIT 10;"`<br>> do<br>> echo -n -e "$usr "<br>> done<br>> <br>> sleep 1;<br>> done<br>> <br>> <br>> It makes a new connection on every loop iteration, so when running it<br>> from 20 places, it is expected to do 20 * 10 = 200 connections. Still<br>> everything goes to the master and nothing to the slave.<br><br>Hum. Recently we discovered that Solaris platform has problem with<br>load balance. Is this your case?<br><br>If you replace your "SELECT...;" to "SELECT 1";, still you see everything goes to master?<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: http://www.sraoss.co.jp/index_en.php<br>Japanese: http://www.sraoss.co.jp<br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>