Message-ID: <521F61B9.1000709@archonet.com>
Date: Thu, 29 Aug 2013 15:59:05 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130704 Icedove/17.0.7
MIME-Version: 1.0
To: bsreejithin <bsreejithin@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: How clustering for scale out works in PostgreSQL
References: <1377778443804-5768917.post@n5.nabble.com>
In-Reply-To: <1377778443804-5768917.post@n5.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 29/08/13 13:14, bsreejithin wrote:
>
> I am *expecting 1000+ hits to my PostgreSQL DB* and I doubt my standalone DB
> will be able to handle it.

OMG! 1000 hits every year! And "hits" too - not just any type of 
query!!!! :-)

Seriously, if you try describing your setup, what queries make up your 
"hits" and what you mean by 1000 then there are people on this list who 
can tell you what sort of setup you'll need.

While you're away googling though, "replication" is indeed the term you 
want. In particular "hot standby" which lets you run read-only queries 
on the replicas.

-- 
   Richard Huxton
   Archonet Ltd


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance