[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