Re: large database - Mailing list pgsql-general

From David Boreham
Subject Re: large database
Date
Msg-id 50C7431B.3000302@boreham.org
Whole thread Raw
In response to large database  ("Mihai Popa" <mihai@lattica.com>)
Responses effective_cache_size and work_ram  ("ac@hsk.hk" <ac@hsk.hk>)
List pgsql-general
On 12/10/2012 1:26 PM, Mihai Popa wrote:
>
> Second, where should I deploy it? The cloud or a dedicated box?
>
> Amazon seems like the sensible choice; you can scale it up and down as
> needed and backup is handled automatically.
> I was thinking of an x-large RDS instance with 10000 IOPS and 1 TB of
> storage. Would this do, or will I end up with a larger/ more expensive
> instance?
>
> Alternatively I looked at a Dell server with 32 GB of RAM and some
> really good hard drives. But such a box does not come cheap and I don't
> want to keep the pieces if it doesn't cut it
>

Note that it will be much cheaper to buy a machine from the likes of
Newegg or Amazon as parts and put it together yourself, if you have the
time to spare and don't care about a Dell warranty. We've been deploying
64G hex-core Xeon Ivy Bridge boxes with 300G SSD for about $2500.
Another 300G SSD for your database size would add about $1200. The newer
Intel DC-series SSDs should be cheaper, but are not yet available. So as
someone else pointed out you could buy a very capable box outright for
the cost of a few months Amazon fees.

I'm not sure I'd worry too much about how to do backups (Amazon just
copies the data the same as you can, to an external drive) but if you
need things like spare machines, pay a human to manage them and so on,
then there are cost benefits to the cloud approach. It also allows you
to blame someone else if something goes wrong.





pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Problem with aborting entire transactions on error
Next
From: Merlin Moncure
Date:
Subject: Re: Looking for cooperators