From: Matthew Nuzum <mattnuzum@gmail.com>
To: Marc G. Fournier <scrappy@postgresql.org>
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 13:45:25 -0600
Message-ID: <f3c0b4080603061145y61fe3298n101ff51d0fcabcba@mail.gmail.com> (raw)
In-Reply-To: <20060306131355.A1227@ganymede.hub.org>
References: <b2990fb00603060528w634580d3rd3ac3d7f21134e52@mail.gmail.com>
<f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.com>
<20060306131355.A1227@ganymede.hub.org>
On 3/6/06, Marc G. Fournier <scrappy@postgresql.org> wrote:
> On Mon, 6 Mar 2006, Matthew Nuzum wrote:
> > 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?
That's true... I hope I didn't imply that I am anti-vps, I run my own
servers and one of them is dedicated to doing VPS for different
applications. I think they're wonderful.
On 3/6/06, Nagita Karunaratne <nagita.k@gmail.com> wrote:
> From personal experience, would you run Postgres on a linux machine
> (NOT a vps) with 512MB of ram?
>
> Assumining I can keep all my data in memory.
Nagita,
It all depends on performance... I have one postgres database that
runs on a Pentium 350MHz with 128MB of RAM. It does 1 insert per
minute 24 hours per day. Because the load is so low, I can get away
with minimal hardware.
If your application has a lot of inserts/updates then disk speed is
important and can vary greatly from one VPS to another.
If your application is not time-critical than this may be a moot point anyway.
--
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, scrappy@postgresql.org, nagita.k@gmail.com
Subject: Re: Postgres on VPS - how much is enough?
In-Reply-To: <f3c0b4080603061145y61fe3298n101ff51d0fcabcba@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