From: Joshua D. Drake <jd@commandprompt.com>
To: Richard Huxton <dev@archonet.com>
Cc: bsreejithin <bsreejithin@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How clustering for scale out works in PostgreSQL
Date: Thu, 29 Aug 2013 08:08:13 -0700
Message-ID: <521F63DD.3050301@commandprompt.com> (raw)
In-Reply-To: <521F61B9.1000709@archonet.com>
References: <1377778443804-5768917.post@n5.nabble.com>
<521F61B9.1000709@archonet.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 08/29/2013 07:59 AM, Richard Huxton wrote:
>
> 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.
We are going to need a little more detail here. In a normal environment
1000+ "hits" isn't that much, even if the hit is generating a dozen
queries per page.
A more appropriate action would be to consider the amount of transaction
per second and the type of queries the machine will be doing. You will
want to look into replication, hot standby as well as read only scaling
with pgpool-II.
>
> 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.
Sarcasm with new recruits to the community is not the way to go.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
a rose in the deeps of my heart. - W.B. Yeats
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, dev@archonet.com, bsreejithin@gmail.com
Subject: Re: How clustering for scale out works in PostgreSQL
In-Reply-To: <521F63DD.3050301@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox