[pgpool-general: 5164] Re: Cause reads inside transaction go to master

Tatsuo Ishii ishii at sraoss.co.jp
Tue Dec 13 08:17:36 JST 2016

> Hi Experts,
> I understand that reads inside a transaction that follow one or more write statement will go to the master node.
> I would like to know if this is also true that the reads inside a transaction will go to master if
> 1)      they follow a read statement with /*nobalance*/ comment?


> 2)      They follow a read statement from a system table?


> If the above two cases will not cause the reads that follow them in the transaction to go to master will any other type of read would or I just need to have  only a write statement to cause it.

Only a write statement.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list