[postgres-xl-bugs] 答复: Concurrency Issue with Table "distribute by replication"
Shu Zhou
shuzhou at skspruce.net
Wed Apr 25 20:11:42 PDT 2018
Postgres xl version is: Postgres-XL 9.5r1.6
RE [postgres-xl-bugs] Concurrency Issue with Table "distribute by replication"
Hi All,
I meet a concurrency issue when testing PGXL using pgbench.
When I setup pgbench database with ¡°DISTRIBUTE BY HASH¡± for tables, pgbench testing can be run well.
But When I setup pgbench database with ¡°DISTRIBUTE BY REPLICATION¡± for tables, pgbench testing (run with ¡°¨Cc 100 ¨Ct 10¡± ) will be pending by ¡°Update Waiting¡±.
It seems go to dead lock and can not get back. Anyone can help for this? Because I want to using replication table instead of setup slave nodes for datanodes.
Here is environment:
3 NODES: master, worker1,worker2, Every node with 4core, 4G Memory.
Master: GTM(active), GTM-Proxy, Coordinator, Datanode Worke1: GTM(standby), GTM-Proxy, Coordinator, Datanode Woker2: GTM-Proxy, Coordinator, Datanode
all datanode are master, no slaves for datanodes.
Configure as following:
shared_buffers = 128MB
dynamic_shared_memory_type = posix
max_connection = 2000
max_pool_size = 65535
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-bugs-postgres-xl.org/attachments/20180426/ab33c06a/attachment.html>
More information about the postgres-xl-bugs
mailing list