From: Matthew Nuzum <mattnuzum@gmail.com>
To: Nagita Karunaratne <nagita.k@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres on VPS - how much is enough?
Date: Mon, 6 Mar 2006 08:56:00 -0600
Message-ID: <f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.com> (raw)
In-Reply-To: <b2990fb00603060528w634580d3rd3ac3d7f21134e52@mail.gmail.com>
References: <b2990fb00603060528w634580d3rd3ac3d7f21134e52@mail.gmail.com>
On 3/6/06, Nagita Karunaratne <nagita.k@gmail.com> wrote:
> How big a VPS would I need to run a Postgres DB.
>
> One application will add about 500 orders per day
> Another will access this data to create and send about 500 emails per day
> A third will access this data to create an after-sales survey for at
> most 500 times per day.
>
> What type of VPS would I need to run a database with this type pf load?
> Is 128 MB ram enough?
> What percentage of a 2.8 GHz CPU would be required?
My problem with running PG inside of a VPS was that the VPS used a
virtual filesystem... basically, a single file that had been formatted
and loop mounted so that it looked like a regular hard drive.
Unfortunately, it was very slow. The difference between my application
and yours is that mine well more than filled the 1GB of RAM that I had
allocated. If your data will fit comfortably into RAM then you may be
fine.
If you really want to know how it will work, try running it yourself.
Two projects that make this really easy and free is the colinux
project[1] which allows you to run a linux VPS in Windows and the
linux-vserver project[2] which is free software that works on pretty
much any linux OS.
Try it out, tinker with the values and that way you won't have to
guess when making your purchase decission.
[1] http://www.colinux.org/ Coperative Linux
[2] http://linux-vserver.org/ Linux-vserver project
--
Matthew Nuzum
www.bearfruit.org
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: mattnuzum@gmail.com, nagita.k@gmail.com
Subject: Re: Postgres on VPS - how much is enough?
In-Reply-To: <f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.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