From: Marc G. Fournier <scrappy@postgresql.org>
To: newz@bearfruit.org
Cc: 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 13:14:45 -0400 (AST)
Message-ID: <20060306131355.A1227@ganymede.hub.org> (raw)
In-Reply-To: <f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.com>
References: <b2990fb00603060528w634580d3rd3ac3d7f21134e52@mail.gmail.com>
<f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.com>
On Mon, 6 Mar 2006, Matthew Nuzum wrote:
> 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.
We host VPSs here (http://www.hub.org) and don't use the 'single file,
virtual file system' to put them into ... it must depend on where you
host?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
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: scrappy@postgresql.org, newz@bearfruit.org, nagita.k@gmail.com
Subject: Re: Postgres on VPS - how much is enough?
In-Reply-To: <20060306131355.A1227@ganymede.hub.org>
* 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