CODEWITHSUNDEEP
postgres-xl
user3652621
user3652621

Reputation: 3634

Setting Up Postgres-XL on Single Machine Configuration

I was wondering if anyone here has any experience installing Postgres-XL, the new open-source multi-thread version of PostgreSQL. I'm planning to migrate a 1-2 TB set of databases from regular Postgres 9.3 to XL and was wondering if anyone here has any advice or any online resources (besides the link above) that they could point me to. Specifically on how to set up the installation to work on a single-machine installation -- the idea here is to take advantage of the multiple (8) processor cores for faster (parallelized) queries.

I'm on RHEL 6.5 on an HP ProLiant DL380p (Gen8) with 8 cores, 32Gb RAM and a few 10k-rpm drives in a RAID 5 configuration.

Thanks!

Upvotes: 3

Views: 2399

Answers (2)

BrianC
BrianC

Reputation: 1822

You might be misunderstanding what Posgres-XL is. It is not for multi-threading as you describe. All databases are multi-threading. Posgres-XL is for very large multi-node clusters to support very large scale parallel processing. It requires a minimum of two nodes just for a base setup. One node for the transaction manger, and one for a coordinator and data node. If you want to run on one node then you should just use standard Postgres. Running Postgres-XL on a single node would be extremely slow and pointless.

Upvotes: 0

kakoni
kakoni

Reputation: 5140

So was searching around the same topic. Easiest way would be to use docker, heres a blog post about it Postgres-XL: a docker container

And here you can find quite recent instructions how to deploy onto single rhel machine using Chef. Deploying Postgres-XL in 2-minutes with Chef/serverspec

Upvotes: 3

Related Questions