News for hackers. Stuff that matters.
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by digitalzombie on Friday October 31, 2014 @03:56PM (#8540776)
I wish postgresql was easy to cluster.

I tried google'n for tutorials but there are none.

There are no books on clustering or sharding postgresql too? At least I haven't found any.

Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by brianwawok on Friday October 31, 2014 @04:02PM (#8540815)
It is tricky. It is also hard to make a real FT postgresql instance, as most tutorials have a single pgpool node doing the load balancing, which shifts the SPOF to the pgpool node. You can do it more or less with a virtual IP ala http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_maste...

To add sharding on top of that is a similar tutorial, but even more complicated.

Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers by takeda on Friday October 31, 2014 @05:32PM (#8541228)
What about Postgres-XL?

I'm genuinely asking. I did not use it yet, but when I was researching database design subject that was my assumption we would use if we need to scale horizontally.