On Wed, May 27, 2009 at 1:57 PM, Alan McKay <alan.mckay@xxxxxxxxx> wrote:
Hey folks,
I have done some googling and found a few things on the matter. But
am looking for some suggestions from the experts out there.
Got any good pointers for reading material to help me get up to speed
on PostgreSQL clustering? What options are available? What are the
issues? Terminology. I'm pretty new to the whole data-warehouse
thing. And once I do all the reading, I'll even be open to product
recommendations :-)
And in particular since I already have heard of this particular
product - are there any opinions on Continuent?
What's your specific use case? Different types of clustering behave differently depending on what you're trying to do.
If you're looking to parallelize large BI type queries something like GridSQL or PGPool may make sense. If you're looking for more of an OLTP solution, or multi-master replication, pgCluster will make more sense.
--Scott
