Re: [PERFORM] Postgres Clustering

On Wed, May 27, 2009 at 1:57 PM, Alan McKay <alan(dot)mckay(at)gmail(dot)com> 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