Message-ID: <5509D404.5050108@commandprompt.com>
Date: Wed, 18 Mar 2015 12:37:40 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.5.0
MIME-Version: 1.0
To: vjoshi@zetainteractive.com, pgsql-performance@postgresql.org,
 pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hardware Configuration and other Stuff
References: <82780c1beb8bc319692c2455c5c3ab38@mail.gmail.com>
In-Reply-To: <82780c1beb8bc319692c2455c5c3ab38@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


On 03/18/2015 12:07 PM, Vivekanand Joshi wrote:

>
> Here are few questions:
>
> 1.) I don't need a load balancing solution. It must be high availability
> server and I can work with asynchronous replication. The most important
> thing here would be recovery should be as fast as possible.
>
> What approach would you recommend?

LinuxHA + Corosync/Pacemaker etc...

>
> 2.) Recommendations on indexes, WAL, table spaces. I am not asking about
> on which key I need to make indexes, but an high level approach about
> how to keep them? This might come out as a weird question to many but
> please excuse me for being a novice.

This is too broad of a question without understanding the hardware it 
will be on.


>
> *Most Important Question:*
>
> 3.) What would be the ideal hardware configuration for this requirement?
> I know there is not a one-stop answer for this, but let's take it is a
> starting point. We can come to a proper conclusion after a discussion.
>
> What are the best on-line resources/books which can tell us about the
> hardware requirements?

And see above. You need a consultant. I am sure you will get some decent 
responses but this isn't just about PostgreSQL, this is about 
architecture of a rather complex solution and a migration.

Sincerely,

Joshua D. Drake


-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, @cmdpromptinc

Now I get it: your service is designed for a customer
base that grew up with Facebook, watches Japanese seizure
robot anime, and has the attention span of a gnat.
I'm not that user., "Tyler Riddle"


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