How clustering for scale out works in PostgreSQL

From: bsreejithin <bsreejithin(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How clustering for scale out works in PostgreSQL
Date: 2013-08-29 12:14:03
Message-ID: 1377778443804-5768917.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


I am *expecting 1000+ hits to my PostgreSQL DB* and I doubt my standalone DB
will be able to handle it.

So I want to *scale out by adding more servers to share the load*. For this,
I want to do clustering.

I am *curious to know how clustering works in PostgreSQL.* (I don't want to
know how to setup cluster - as of now. Just want to know how clustering
works).

When I look at some of the content available while googling, I am getting
more and more confused, as I find that in most of the sites, clustering is
used interchangeably with replication.

*My purpose is scale out to handle more load, not high availability.*

Can any one please help me with the details or guide me to use urls.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-clustering-for-scale-out-works-in-PostgreSQL-tp5768917.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2013-08-29 14:59:05 Re: How clustering for scale out works in PostgreSQL
Previous Message hubert depesz lubaczewski 2013-08-29 11:00:22 Re: Poor OFFSET performance in PostgreSQL 9.1.6