Skip site navigation (1) Skip section navigation (2)

Re: Hosted servers with good DB disk performance?

From: Craig James <craig_james(at)emolecules(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Hosted servers with good DB disk performance?
Date: 2009-05-26 22:28:08
Message-ID: 4A1C6CF8.7000705@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-performance
Greg Smith wrote:
> What I'd love to have is a way to rent a fairly serious piece of 
> dedicated hardware, ideally with multiple (at least 4) hard drives in a 
> RAID configuration and a battery-backed write cache.  The cache is 
> negotiable. Linux would be preferred, FreeBSD or Solaris would also 
> work; not Windows though (see "good DB performance").

We tried this with poor results.  Most of the co-location and server-farm places are set up with generic systems that are optimized for small-to-medium-sized web sites.  They use MySQL and are surprised to hear there's an alternative open-source DB.  They claim to be able to create custom configurations, but it's a lie.

The problem is that they run on thin profit margins, and their techs are mostly ignorant, they just follow scripts.  If something goes wrong, or they make an error, you can't get anything through their thick heads.  And you can't go down there and fix it yourself.

For example, we told them EXACTLY how to set up our system, but they decided that automatic monthly RPM OS updates couldn't hurt.  So the first of the month, we in the morning to find that Linux had been updated to libraries that were incompatible with our own software, the system automatically rebooted and our web site was dead.  And many similar incidents.

We finally bought some nice Dell servers and found a co-location site that provides us all the infrastructure (reliable power, internet, cooling, security...), and we're in charge of the computers.  We've never looked back.

Craig

In response to

Responses

pgsql-performance by date

Next:From: Marcin StępnickiDate: 2009-05-26 22:50:47
Subject: Re: Hosted servers with good DB disk performance?
Previous:From: Jerry ChamplinDate: 2009-05-26 22:17:37
Subject: Re: Hosted servers with good DB disk performance?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group