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!
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