Re: How clustering for scale out works in PostgreSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: bsreejithin <bsreejithin(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How clustering for scale out works in PostgreSQL
Date: 2013-08-29 14:59:05
Message-ID: 521F61B9.1000709@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2013-08-29 15:08:13 Re: How clustering for scale out works in PostgreSQL
Previous Message bsreejithin 2013-08-29 12:14:03 How clustering for scale out works in PostgreSQL