Questions tagged [postgres-xl]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
0 answers
39 views

UPDATE ... RETURNING * with large results error

I am using Postgres-XL (Distributed version of Postgres) When I run the query: UPDATE <table> SET <column> = <value> WHERE <conditions> RETURNING *; and the result has ...
DMin's user avatar
  • 163
0 votes
1 answer
474 views

Postgres-XL adding GTM Proxy seems to do nothing

I've set up a Postgres-XL cluster using this recipe: GTM: hostname=host1 nodename=gtm Coordinator: hostname=host2 nodename=coord1 Datanode1: hostname=host3 nodename=datanode1 Datanode2: hostname=...
TungstenX's user avatar
2 votes
1 answer
314 views

Postgres-XL: SQueue timeout while waiting for Consumers finishing

We are running a pg-xl cluster: 1 gtm 2 coords 2 datanodes (+2 slaves) Everything works ok except for some medium queries (10 joins + group by). These queries always take 10.xx seconds. There is a 10-...
dbaq's user avatar
  • 121
0 votes
1 answer
1k views

Postgres-XL cluster

I'm trying to create a Postgres-XL cluster on 4 servers. I've followed the recipe on https://ruihaijiang.wordpress.com/2015/09/17/postgres-xl-installation-example-on-linux/ (Note: update to pgxc_ctl....
TungstenX's user avatar
1 vote
1 answer
378 views

Failed To Insert Data Into Tables Using Postgres-XL and 4 Datanode

Recently, I have installed Postgres-XL-9.5r1.5 in a R630, 16 cores, 16 GB RAM. I configured 1 GTM, 1 Coordinator, and 4 Datanodes. I created a simple table sales_small_cat CREATE TABLE ...
Dwi Santoso's user avatar