Re: Postgres on VPS - how much is enough?

From: "Nagita Karunaratne" <nagita(dot)k(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres on VPS - how much is enough?
Date: 2006-03-06 16:52:44
Message-ID: b2990fb00603060852l6e6f02b7n6a8c3bfe81cf7f6a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thanks for the replies,

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.

Thanks,
Nagita

> 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.
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Marc G. Fournier 2006-03-06 17:14:45 Re: Postgres on VPS - how much is enough?
Previous Message Joost Kraaijeveld 2006-03-06 15:29:49 Can anyone explain this pgbench results?