Re: Postgres on VPS - how much is enough?

On Mon, 6 Mar 2006, Matthew Nuzum wrote:

> On 3/6/06, Nagita Karunaratne <nagita(dot)k(at)gmail(dot)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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664