Re: large database

On 11/12/12 23:25, Chris Angelico wrote:
> On Tue, Dec 11, 2012 at 7:26 AM, Mihai Popa <mihai(at)lattica(dot)com> wrote:
>> Second, where should I deploy it? The cloud or a dedicated box?
> Forget cloud. For similar money, you can get dedicated hosting with
> much more reliable performance. We've been looking at places to deploy
> a new service, and to that end, we booked a few cloud instances and
> started playing. Bang for buck, even the lower-end dedicated servers
> (eg about $35/month) majorly outdo Amazon cloud instances.
>
> But don't take someone's word for it. Amazon let you trial their
> system for a year, up to (I think) ~750 computation hours per month,
> of their basic instance type. You can find out for yourself exactly
> how unsuitable it is! :)
>
> The fact is that cloud platforms offer flexibility, and that
> flexibility comes at a significant cost. I don't think PostgreSQL can
> adequately exploit X nodes with 600MB RAM each, while it _can_ make
> excellent use of a single computer with gobs (that's a new SI unit,
> you know) of memory.
>
> Incidentally, I've heard tell that cloud instances can vary enormously
> in performance through the day or week, but we did some cursory
> testing and didn't experience that. That doesn't prove you won't have
> problems, of course, but it's one of the purported downsides of
> clouding that clearly isn't as universal as I've heard said.
>
> ChrisA
>
>
Would you say the issue is cloudy?
(I'm not being entirely facetious!)

Cheers,
Gavin