O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting up a Postgres-XL cluster

Here in this recipe, we are going to set up a Postgres XL cluster, which is a scalable PostgreSQL cluster, to solve the big data processing challenges.

Getting ready

Postgres-XL is a horizontally scalable open source cluster, which has a set of individual dedicated components to scale PostgreSQL to multiple nodes. Postgre-XL (extensible lattice) gives us more convenience in distributing the data across the nodes or replicating the data across the nodes.

How to do it...

Note that:

node1 -- ec2-54-164-174-117.compute-1.amazonaws.com -- 172-30-1-154
node2 -- ec2-54-152-235-194.compute-1.amazonaws.com -- 172-30-1-155
node3 -- ec2-54-165-7-151.compute-1.amazonaws.com -- 172-30-1-156
node4 -- ec2-54-152-210-130.compute-1.amazonaws.com ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required