Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.80)
	(envelope-from
 <pgsql-performance-owner+M53913=pgsql-performance-ar@postgresql.org>)
	id 1aYVKL-000363-AO
	for pgsql-performance@arkaria.postgresql.org; Wed, 24 Feb 2016 09:01:45 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84)
	(envelope-from
 <pgsql-performance-owner+M53913=pgsql-performance-ar@postgresql.org>)
	id 1aYVKK-0003ne-63
	for pgsql-performance@arkaria.postgresql.org; Wed, 24 Feb 2016 09:01:44 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84)
	(envelope-from <gunnar.bluth.extern@elster.de>)
	id 1aYVKJ-0003nT-Jp
	for pgsql-performance@postgresql.org; Wed, 24 Feb 2016 09:01:43 +0000
Received: from blog.elster.de ([217.6.110.187] helo=elster.de)
	by magus.postgresql.org with esmtp (Exim 4.84)
	(envelope-from <gunnar.bluth.extern@elster.de>)
	id 1aYVKD-00060m-3f
	for pgsql-performance@postgresql.org; Wed, 24 Feb 2016 09:01:42 +0000
Received: from edmzarafa01.een.elster.de ([10.1.20.13]:36642)
	by elster.de with [XMail 1.27 ESMTP Server]
	id <S1071764> for <pgsql-performance@postgresql.org> from
 <gunnar.bluth.extern@elster.de>;
	Wed, 24 Feb 2016 10:01:35 +0100
Received: from [10.200.128.23] (enmfwa02ext.een.elster.de [192.168.90.2])
	by edmzarafa01.een.elster.de (Postfix) with ESMTPSA id 18FDE2D6035D
	for <pgsql-performance@postgresql.org>; Wed, 24 Feb 2016 10:01:35 +0100 (CET)
Subject: Re: Cloud versus buying my own iron
To: pgsql-performance@postgresql.org
References: 
 <CAFwQ8rdJ58hpu6GRPrJahj4-p2T_B0eONMK8uLEJ3qEJa+b-Ug@mail.gmail.com>
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth.extern@elster.de>
X-Enigmail-Draft-Status: N1110
Message-ID: <56CD716A.4090402@elster.de>
Date: Wed, 24 Feb 2016 10:01:30 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.5.1
MIME-Version: 1.0
In-Reply-To: 
 <CAFwQ8rdJ58hpu6GRPrJahj4-p2T_B0eONMK8uLEJ3qEJa+b-Ug@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -0.5 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Am 24.02.2016 um 06:06 schrieb Craig James:
> At some point in the next year we're going to reconsider our hosting
> environment, currently consisting of several medium-sized servers (2x4
> CPUs, 48GB RAM, 12-disk RAID system with 8 in RAID 10 and 2 in RAID 1
> for WAL). We use barman to keep a hot standby and an archive.
> 
> The last time we dug into this, we were initially excited, but our
> excitement turned to disappointment when we calculated the real costs of
> hosted services, and the constraints on performance and customizability.
> 
> Due to the nature of our business, we need a system where we can install
> plug-ins to Postgres. I expect that alone will limit our choices. In
> addition to our Postgres database, we run a fairly ordinary Apache web site.
> 
> There is constant chatter in this group about buying servers vs. the
> various hosted services. Does anyone have any sort of summary comparison
> of the various solutions out there? Or is it just a matter of
> researching it myself and maybe doing some benchmarking and price
> comparisons?

For starters, did you see Josh Berkus' presentation on the topic?
  https://www.youtube.com/watch?v=WV5P2DgxPoI

I for myself would probably always go the "own iron" road, but alas!
that's just the way I feel about control. And I'm kind of a Linux
oldshot, so managing a (hosted root) server doesn't scare me off.

OTOH, I do see the advantages of having things like monitoring, backup,
HDD replacements etc. done for you. Which is essentially what you pay for.

In essence, there's obviously no silver bullet ;-)

Best regards,
-- 
Gunnar "Nick" Bluth
DBA ELSTER

Tel:   +49 911/991-4665
Mobil: +49 172/8853339


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