<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
On 06/01/2012 03:47 PM, Lazaro Ruben Garcia Martinez wrote:
<blockquote
cite="mid:baee08d2-2987-4e14-ad3e-363659115a20@ucimail3.uci.cu"
type="cite">
<style type="text/css">p { margin: 0; }</style>
<div style="font-family: Times New Roman; font-size: 14pt; color:
#000000">Would you try a test with pgbench?<a
moz-do-not-send="true" href="http://www.uci.cu/"> <br>
</a><br>
</div>
</blockquote>
<br>
Here it goes. I created a simple pgbench script:<br>
<br>
\setrandom delay 1 500<br>
SELECT 1;<br>
\sleep :delay ms<br>
SELECT :delay;<br>
<br>
<br>
Then started it:<br>
<br>
pgbench -U postgres -d pgbench -h db1 -c 210 -C -j 7 -f pgbench.sql<br>
<br>
<br>
The last lines of output:<br>
<br>
transaction type: Custom query<br>
scaling factor: 1<br>
query mode: simple<br>
number of clients: 210<br>
number of threads: 7<br>
number of transactions per client: 10<br>
number of transactions actually processed: 2100/2100<br>
tps = 15.937769 (including connections establishing)<br>
tps = 929.128364 (excluding connections establishing)<br>
<br>
<br>
And still nothing in the log of db2 (the slave node). Everything is
sent to db1. Meanwhile when visiting the /status.php script of
pgpoolAdmin, I see the "SELECT pg_is_in_recovery()" query twice in
the logs of both servers. The status says:<br>
<br>
db1 5432 Up. Disconnect. Running as primary server 0.500<br>
db2 5432 Up. Disconnect. Running as standby server 0.500<br>
<br>
<br>
In pgpool.conf:<br>
<br>
load_balance_mode = true<br>
master_slave_mode = true<br>
master_slave_sub_mode = 'stream'<br>
<br>
<br>
--<br>
Kouber Saparev<br>
</body>
</html>