[pgpool-general: 1506] Re: Load balancing changes between 2.x and 3.x

[Tatsuo Ishii]

> On 03/14/2013 05:58 PM, Tatsuo Ishii wrote:
> 
>>> Correct. However, it is my understanding that if I am running 2.x and
>>> I do this:
>>>
>>> BEGIN;
>>> SELECT update_function(); -- write stuff to database
>>> COMMIT;
>>>
>>> It will not be load balanced. However, if I am using 3.x it would
>>> be. What I want to be able to do is execute functions via pgpool 3.x
>>> and have it not be load balanced.
>>
>> Oh I see. You can specify white_function_list and black_function_list
>> directive. i.e.
>>
>> white_function_list = ''
>> black_function_list = 'update_function'
>>
>> will load balance any function except "update_function".
> 
> That is an interesting work around but not very functional on a system
> that has been developed to be database centric. If I have 200
> functions that write data, that is an awful long list to keep track
> of. Something to consider for the future. It is nice the work around
> exists however. Thank you for the information.

You can use regular expressions for the function name. So if you are
luck enough to name your 200 functions starting with "foo", you can specify like;

black_function_list = 'foo.*'
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp