postgres-xl is a maintained, updated fork of the multi-master PostgreSQL fork postgres-XC.
postgres-xl is a maintained, updated fork of the multi-master PostgreSQL fork postgres-XC. See http://www.postgres-xl.org/
Questions tagged [postgres-xl]
52 questions
0
votes
1 answer
How to set SEQUENCE as DEFAULT in Postgres-XL?
I use Postgres-XL 10R1.
I created table packs and sequence packs_id_seq same SQL:
CREATE TABLE packs (
id integer NOT NULL,
name varchar(10) NOT NULL
) DISTRIBUTE BY REPLICATION;
CREATE SEQUENCE packs_id_seq
AS integer
START WITH 1
…
0
votes
2 answers
PostGIS extension on Postgres-xl
I'm trying to deploy a PostGIS cluster using Postgres-XL on AWS, for this I have the next architecture:
SO: ubuntu
1 GTM (172.31.45.190)
1 Coordinator (172.31.45.191)
2 Datanodes (172.31.45.192 and 172.31.45.193)
I had my cluster running but I…
Leonel Castañeda
- 11
- 3
0
votes
2 answers
postgres-xl left join takes too long to execute
Postgres-XL 9.5r1.6 consists of a gtm, a coordinator and two datanodes.
There are three tables a, b and c which implements a many-to-many relationship:
create table a(id int, name text, uid int) distribute by hash(uid);
create table b(id int, name…
Ali
- 79
- 9
0
votes
0 answers
Is it possible to assign distributed column values to specific Postgres-XL nodes?
We would like to be able to use distributed tables where some nodes would have multiple tenants and other nodes may only have one or two (e.g. put a massive, high-traffic tenant by themselves, but group multiple small tenants together).
I see…
markvr4
- 21
- 5
0
votes
2 answers
Greenplum vs Postgres-XL
I was looking at those two massively parallel databases: Postgres-XL and Greenplum.
Problem is, I do not know how to choose between them, because they both seems the same: both are open sourced, based on PostgreSQL, both use MPP, both have similiar…
MacakM
- 1,804
- 3
- 23
- 46
0
votes
1 answer
Creating Trigger With pl/Python on Postgres
I am working with postgres-xl 9.5 , it is not supporting triggers. I am trying to write trigger function by using python it should replace
BEFORE INSERT ON tbl
FOR EACH ROW EXECUTE PROCEDURE fnx()
Thanks
Stas Rozen
- 1
- 1
0
votes
1 answer
When you have multiple coordinators in postgres-XL, do you have any floating ip which re-direct to one coordinator?
In minimum requirements, to build a master slave system, I must have two coordinators, one master and one slave.
So when you build your connection string, what is the target IP?
master?
slave?
or some floating ip to manage this
Alexandre Ribeiro
- 127
- 10
0
votes
2 answers
Postgres-XL Load Balancing
Postgres-XL Documentations and also overview describes load balancing as a distinct part of the system.
Am I correct and it is up to Postgres-XL users to load balance or is there specific a way of doing load balance (using load information of…
Sefa
- 370
- 2
- 11
0
votes
1 answer
Installing Postgres-XL with PostGis
Problem: I am trying to install Postgres-XL with PostGis enabled on a 3 node cluster. I managed to install Postgres-XL on 3 nodes with 1 GTM, 1 Co-ordinator & 1 Data Node. Now the problem is when I try to install the PostGis extension on DataNode it…
kaxil
- 17,706
- 2
- 59
- 78
0
votes
0 answers
bind postgres-xl coordinator to listen only on specific interface
I'm trying to bind coordinator to only listen on specific interface. It seems the listen_addressses option is being ignored when specified within postgresql.conf on coordinator.
There is another file within coordinator data directory called…
Greg0ry
- 931
- 8
- 25
0
votes
1 answer
Can you use Postgres-XL's Round Robbin or Hash data sharding options and have redundancy
The Postgres-XL 9.5 documentation says that when using the Round Robbin or Hashing data sharding options that each data element is only written to a single node. It does not give any other details beyond that.
Is data really not stored on more…
BrianC
- 1,793
- 1
- 18
- 26
0
votes
1 answer
Postgres XL add data node to existing cluster
This is my Postgres XL 9.5 configuration:
GTM
Cordinator
datanode1
datanode2.
For above mentioned cluster I have created database DB1 which contains table with 50mln rows and distributed by hash between 2 nodes. After that I add 2 more nodes. But…
Rafa
- 1
- 2
0
votes
1 answer
How to optimize TPS and overall database performance in Postgres XL?
I've been trying to log some benchmark for Postgres XL using pgbench. I've used pgbench in a 78MB database with a json column. And to my knowledge, I cannot judge if my output result is okay to proceed with. I mean with what respect should I…
Pragun
- 1,123
- 8
- 20
0
votes
1 answer
How transparent should losing access to a Postgres-XL datanode be?
I have set-up a testing Postgres-XL cluster with the following architecture:
gtm - vm00
coord1+datanode1 - vm01
coord2+datanode2 - vm02
I created a new database, which contains a table that is distributed by replication. This means that I should…
rasebo
- 957
- 1
- 13
- 21
0
votes
1 answer
How can I drop a Postgres-XL database that has its name starting with a digit?
I am really new to Postgres-XL, and I have just created a testing cluster, running postgres-xl-9.5r1.3.
It's set-up on three nodes, one node GTM, and two with both a Coordinator and a Datanode on each.
I am planning on load balancing between these…
rasebo
- 957
- 1
- 13
- 21