[Pgpool-general] white_function_list parameter

[Tatsuo Ishii]

> "white_function_list 
> 
> ... In master slave mode, SELECTs are sent to master(primary) only. "
> (Taken from pgpool-II web site)
> 
>  
> 
> Is this true? What about when working with streaming replication where I
> want the hot-standby to run read-only queries (SELECTs)?

Sorry for poor English. Actually pgpool-II allows the hot-standby to
run read-only queries (SELECTs).

Following is revised description. Please do not hesitate to enhance
it!

<dt>white_function_list
<dd>
<p>
Specify comma separated function name list, those <strong>do not</strong> update database.
SELECTs using functions not specified in this list are not load balanced, replicated if in replication mode.
In master slave mode, such SELECTs are sent to master(primary) only.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp