pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Andrew Hammond <andrew.george.hammond@gmail.com>
To: Niklas Saers <niklassaers@gmail.com>
Cc: pgsql-jobs@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Looking for database hosting
Date: Sun, 19 Aug 2007 12:48:10 -0700
Message-ID: <5a0a9d6f0708191248t20dec076q535d85d900f565a8@mail.gmail.com> (raw)
In-Reply-To: <87C876AF-0EA2-4FD6-BAA6-2E2F02182EA3@gmail.com>
References: <87C876AF-0EA2-4FD6-BAA6-2E2F02182EA3@gmail.com>
Nik, you may be underestimating just how much performance can be obtained
from a single database server. For example, an IBM p595 server connected to
an array of ds8300 storage devices could reasonably be expected to provide
several orders of magnitude more performance when compared to commodity
hardware. In commodity space (albeit, just barely), a 16 core opteron
running (the admittedly yet-to-be-released) FreeBSD 7, and a suitably
provisioned SAN should also enormously outperform a beige-box solution, and
at a fraction of the cost. If it's performance you care about then the
pgsql-performance list (which I have cc'd) is the place to talk about it.
I realize this doesn't address your desire to get out of database server
administration. I am not aware of any company which provides database
hosting, further I'm not entirely convinced that's a viable business
solution. The technical issues (security, latency and reliability are the
ones that immediately come to mind) associated with a hosted database server
solution suggest to me that this would not be economically viable. The
business issues around out-sourcing a critical, if not central component of
your architecture seem, at least to me, to be insurmountable.
Andrew
On 8/19/07, Niklas Saers <niklassaers@gmail.com> wrote:
>
> Hi,
> the company I'm doing work for is expecting a 20 times increase in
> data and seeks a 10 times increase in performance. Having pushed our
> database server to the limit daily for the past few months we have
> decided we'd prefer to be database users rather than database server
> admins. :-)
>
> Are you or can you recommend a database hosting company that is good
> for clients that require more power than what a single database
> server can offer?
>
> Cheers
>
> Nik
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
view thread (5+ messages) latest in thread
Message-ID: <5a0a9d6f0708191248t20dec076q535d85d900f565a8@mail.gmail.com> Permalink: ../5a0a9d6f0708191248t20dec076q535d85d900f565a8@mail.gmail.com/ Also on: postgresql.org/message-id/5a0a9d6f0708191248t20dec076q535d85d900f565a8@mail.gmail.com ·
reply
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 from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-performance@postgresql.org Cc: andrew.george.hammond@gmail.com, niklassaers@gmail.com, pgsql-jobs@postgresql.org Subject: Re: Looking for database hosting In-Reply-To: <5a0a9d6f0708191248t20dec076q535d85d900f565a8@mail.gmail.com> References: <87C876AF-0EA2-4FD6-BAA6-2E2F02182EA3@gmail.com> <5a0a9d6f0708191248t20dec076q535d85d900f565a8@mail.gmail.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