From: Some Developer <someukdeveloper@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Best VPS provider for running performant PostgreSQL database server
Date: Mon, 16 Mar 2015 05:08:42 +0000
Message-ID: <5506655A.9020801@googlemail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
I wasn't sure whether to post this in general, admin or performance but
since it is basically a performance question I went with performance.
I'm about to launch a new a website that is written using the Django web
framework and has PostgreSQL as the database server. Unfortunately I
can't afford to get dedicated hardware at the launch of the website as I
won't be making money off it for a couple of months (maybe longer).
So I was wondering if anyone had any recommendations for decent VPS
providers that have good hardware specs for running a PostgreSQL server?
I'll be using PostgreSQL 9.4.
The database is likely to be quite small (under 1GB) for quite sometime
so should I go for double the size of the database in RAM so I can fit
it all in memory if required? The database will be mainly read only with
only a small number of writes (although as new features are added the
number of database write operations will increase).
I guess SSDs are essential these days but am I right about the amount of
RAM? Is there anything else I should be looking out for? I'll just be
running PostgreSQL on the VPS, the web server and app server will be run
on different VPSs.
In the past I've used Linode, Digital Ocean, Vultr and RamNode. I've
become disheartened by Digital Ocean so don't want to use them for this
project.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: someukdeveloper@gmail.com
Subject: Re: Best VPS provider for running performant PostgreSQL database server
In-Reply-To: <5506655A.9020801@googlemail.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