Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXNGp-0005D2-HR for pgsql-performance@arkaria.postgresql.org; Mon, 16 Mar 2015 05:08:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXNGo-0003Aq-SE for pgsql-performance@arkaria.postgresql.org; Mon, 16 Mar 2015 05:08:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YXNGn-0003Ak-N6 for pgsql-performance@postgresql.org; Mon, 16 Mar 2015 05:08:54 +0000 Received: from mail-wg0-x230.google.com ([2a00:1450:400c:c00::230]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YXNGg-0006Vo-BV for pgsql-performance@postgresql.org; Mon, 16 Mar 2015 05:08:51 +0000 Received: by wgbcc7 with SMTP id cc7so30439044wgb.0 for ; Sun, 15 Mar 2015 22:08:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:message-id:date:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=PIZX5ngVSXM7Y85XlucoUN5izJM0NAUUO1auRexK7Eo=; b=xLUrLQp8llHcTZUnFg9aGuogEWMrn3jxAMv+mR36LzRQGOPYylZSqwL/M+zf026Whd fMz7I1EslanqEvraskb0w1Fwp081n3vkTc7A+An464/XRdbdMTIYqE73tuXwqNDB29XY oL84I+zCLpNdOumDKO4pZjqoc/N3JVon4RVkyQ4AEC5YOOV/bwHz5a15T+DrXiWknAtD tMP1dn2PRbLxRcwXlMU2pSKZY8sk6fiLhMxUFP6DV0cX35NTo5V+bIoDJARA/WkiP35N e2mSHdjlhzOevpC3yCR8CBCEIaIvt42FWYedRyhUkHPXOxkGYaUzuoDKe+RACV331MQE 5Fuw== X-Received: by 10.180.79.65 with SMTP id h1mr118335927wix.59.1426482523648; Sun, 15 Mar 2015 22:08:43 -0700 (PDT) Received: from [192.168.1.169] (cpc1-reig5-2-0-cust251.6-3.cable.virginm.net. [81.106.27.252]) by mx.google.com with ESMTPSA id nd15sm13617341wic.8.2015.03.15.22.08.42 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 15 Mar 2015 22:08:42 -0700 (PDT) From: Some Developer X-Google-Original-From: Some Developer Message-ID: <5506655A.9020801@googlemail.com> Date: Mon, 16 Mar 2015 05:08:42 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Best VPS provider for running performant PostgreSQL database server Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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