Database Reference
In-Depth Information
It will result in two parallel calls to partitions
1
and
2
(as using
hash-
text(i_username)
tom and bob map to partition
1
and mary to partition
2
of total
for partitions as explained earlier), with the following arguments for partition
1
:
SELECT * FROM create_new_users(
ARRAY['bob', 'tom'],
ARRAY['6c6e5b564fb0b192f66b2a0a60c751bb',
'edcc36c33f7529f430a1bc6eb7191dfe'],
ARRAY['bob@mail.com','tom@mail.com']
);
And this for partition
2
:
SELECT * FROM create_new_users(
ARRAY['jane'],
ARRAY['cbbf391d3ef4c60afd851d851bda2dc8'],
ARRAY['jane@mail.com']
);
Then, it returns a concatenation of the results:
status | message
--------+---------
200 | OK
200 | OK
200 | OK
(3 rows)
Distribution of data
First, what is a cluster in PL/Proxy? Well, the cluster is a set of partitions that make
up the whole database. Each cluster consists of a number of partitions as determ-
ined by the cluster configuration. Each partition is uniquely specified by its connect
string. The list of connection strings is what makes up a cluster. The position of the