Postgres Professional
   

Re: Hosted servers with good DB disk performance?

From: David Wall
Subject: Re: Hosted servers with good DB disk performance?
Date: ,
Msg-id: 4A1D5F4E.4010409@computer.org
(view: Whole thread, Raw)
In response to: Re: Hosted servers with good DB disk performance?  ("Joshua D. Drake")
List: pgsql-performance

Tree view

Hosted servers with good DB disk performance?  (Greg Smith, )
 Re: Hosted servers with good DB disk performance?  (Craig James, )
  Re: Hosted servers with good DB disk performance?  (Erik Aronesty, )
 Re: Hosted servers with good DB disk performance?  (Marcin Stępnicki, )
 Re: Hosted servers with good DB disk performance?  ("Jerry Champlin", )
 Re: Hosted servers with good DB disk performance?  ("Joshua D. Drake", )
  Re: Hosted servers with good DB disk performance?  (Greg Smith, )
   Re: Hosted servers with good DB disk performance?  (Scott Carey, )
    Re: Hosted servers with good DB disk performance?  (Scott Marlowe, )
     Re: Hosted servers with good DB disk performance?  (Scott Carey, )
      Re: Hosted servers with good DB disk performance?  (Scott Carey, )
      Re: Hosted servers with good DB disk performance?  (Scott Marlowe, )
       Re: Hosted servers with good DB disk performance?  (Greg Smith, )
     Re: Hosted servers with good DB disk performance?  ("Joshua D. Drake", )
      Re: Hosted servers with good DB disk performance?  (David Wall, )
 Re: Hosted servers with good DB disk performance?  (Dave Page, )
  Re: Hosted servers with good DB disk performance?  (Scott Mead, )
 Re: Hosted servers with good DB disk performance?  (Josh Berkus, )
 Re: Hosted servers with good DB disk performance?  (Ron Mayer, )
 Re: Hosted servers with good DB disk performance?  (Alex Adriaanse, )
 Re: Hosted servers with good DB disk performance?  (Dimitri Fontaine, )
 Re: Hosted servers with good DB disk performance?  ("Markus Wanner", )
  Re: Hosted servers with good DB disk performance?  (Dimitri Fontaine, ) 
> Heh. Well on another consideration any "rental" will out live its cost
> effectiveness in 6 months or less. At least if you own the box, its
> useful for a long period of time.
>
> Heck I got a quad opteron, 2 gig of memory with 2 6402 HP controllers
> and 2 fully loaded MSA30s for 3k. Used of course but still.
>
> The equivalent machine brand new is 10k and the same machine from Rack
> Space is going to be well over 1200.00 a month.
>
Presumably true, but owing the gear means: 1) buying the gear; 2) buying
backup hardware if you need a "shell" or replacement gear to be handy so
if something bad happens you can get back running quickly; 3) a data
center rack to hold the server; 4) bandwidth; 5) monitoring of the
hardware and having a response team available to fix it.

The virtual private server market is interesting, but we've found
various flaws that are make our transition away from owning our own gear
and data center problematic: 1) they may not offer reverse DNS (PTR
records) for your IP which is generally needed if your application sends
out email alerts of any kind; 2) they may have nasty termination clauses
(allowing them to terminate server at any time for any reason without
notice and without giving you access to your code and data stored on the
VPS); and 3) performance will always lag as its virtualized and the
servers may be "over subscribed."

I like the Amazon EC2 solution, though the pricing is overly complex and
they suffer the "no DNS PTR" ability.  But since you can buy just what
you need, you can run warm standby servers or the like and moving your
data from one to the other over the private network costs nothing
extra.  I found their choice of OS confusing (we wanted CentOS, but they
have no Amazon-certified versions), too.

Does anybody have any recommendations for a good VPS provider?

Thanks,
David

pgsql-performance by date:

Previous:
From: Alan McKay
Date:
Subject: Re: Postgres Clustering
Next:
From: Ivan Voras
Date:
Subject: Storing sensor data