From: Joshua D. Drake <jd@commandprompt.com>
To: vjoshi@zetainteractive.com
To: pgsql-performance@postgresql.org
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hardware Configuration and other Stuff
Date: Wed, 18 Mar 2015 12:37:40 -0700
Message-ID: <5509D404.5050108@commandprompt.com> (raw)
In-Reply-To: <82780c1beb8bc319692c2455c5c3ab38@mail.gmail.com>
References: <82780c1beb8bc319692c2455c5c3ab38@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
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, vjoshi@zetainteractive.com, pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Hardware Configuration and other Stuff
In-Reply-To: <5509D404.5050108@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