How should I understand backend_weight config variable?
For example, I have two postgres servers: local and remote.
I would like to execute all SELECT operations on the local server only
/ mostly.
What backend_weight should I use?
backend_hostname0 = 'local'
backend_weight0 = 0
Tatsuo Ishii wrote:
How should I understand backend_weight config variable?
For example, I have two postgres servers: local and remote.
I would like to execute all SELECT operations on the local server only
/ mostly.
What backend_weight should I use?
backend_hostname0 = 'local'
Out of curiosity, how would be such values handled?
backend_hostname0 = 'postgres1'
backend_weight0 = 0
backend_hostname1 = 'postgres2'
backend_weight1 = 1
backend_hostname1 = 'postgres3'
backend_weight1 = 2
postgres1 should not get any reads.
postgres2 should get 33,3(3)%
Tomasz Chmielewski wrote:
Thanks.
Out of curiosity, how would be such values handled?
I made some typos wrt numbers -once again, corrected below:
backend_hostname0 = 'postgres1'
backend_weight0 = 0
backend_hostname1 = 'postgres2'
backend_weight1 = 1
backend_hostname1 = 'postgres3'
features include:
.
.
Let's populate t1:
INSERT INTO t1(id) VALUES(1);
Actual query executed by pgpool-II is:
INSERT INTO t1(id, regdate) VALUES
(1,'2009-11-15 21:35:01.783053+09');
which function will execute ?.
is it send_simplequery_message or another else ?.
Let's populate t1:
INSERT INTO t1(id) VALUES(1);
Actual query executed by pgpool-II is:
INSERT INTO t1(id, regdate) VALUES
(1,'2009-11-15 21:35:01.783053+09');
which function will execute ?.
is it send_simplequery_message or another else ?.
There are several places
Please show configure output.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
Hello Tatsuo,
Thank you for your prompt reply!
My libcrypt.so is here:
/usr/lib/libcrypt.so
This is the full output of the make:
===
make
make all-recursive
make[1]: Entering directory