From: bsreejithin <bsreejithin@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: How clustering for scale out works in PostgreSQL
Date: Thu, 29 Aug 2013 09:13:24 -0700 (PDT)
Message-ID: <1377792804612-5768951.post@n5.nabble.com> (raw)
In-Reply-To: <521F63DD.3050301@commandprompt.com>
References: <1377778443804-5768917.post@n5.nabble.com>
<521F61B9.1000709@archonet.com>
<521F63DD.3050301@commandprompt.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Thanks a lot Joshua and others who have responded..
I am sorry about not putting in more details in my initial post.
What I posted is about a new setup that's going to come up..Discussions are
on whether to setup DB cluster to handle 1000 concurrent users.
DB cluster was thought of because of the following reasons :
A performance testing of the product was done and it was found that the DB
side utilizations were on the higher side with 125 concurrent
users.Application server was 4 Core 12GB RAM , DB server was 4 Core 12GB
RAM.
PostgreSQL version was* 8.2*. Also, I noted that most of the column data
types were declared as bigint, [quite unnecessarily]. ---I am trying to
put-in all details here.
The product team is working on to migrate to version 9.2 and to look at
possible areas where bigint data type can be changed to smaller data types.
The product owner wants to scale up to 1000 concurrent users. So one of the
discussions was to setup up Application level clustering and probably DB
level clustering to share the load (We don't need fail-over or HA here).
For application clustering what we thought is : to have EIGHT 4 Core 12GB
machines.
Currently for DB, the new server we have is : 8 Core 32 GB RAM.
Many here are having doubts whether the DB server will be able to handle
1000 concurrent user connections coming-in from the Application cluster
nodes.
I know that, this is still a generalised questions - but this is the
scenario we have here..
I am putting the question in this forum so that I could get as much opinions
as possible before we decide on what to do next.
To those replying - thanks alot - any help will be very useful..
And the sarcasm is ok, as long as I get to learn :)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-clustering-for-scale-out-works-in-PostgreSQL-tp5768917p5...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
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: bsreejithin@gmail.com
Subject: Re: How clustering for scale out works in PostgreSQL
In-Reply-To: <1377792804612-5768951.post@n5.nabble.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