Re: Postgres on VPS - how much is enough? - Mailing list pgsql-performance

From Nagita Karunaratne
Subject Re: Postgres on VPS - how much is enough?
Date
Msg-id b2990fb00603060852l6e6f02b7n6a8c3bfe81cf7f6a@mail.gmail.com
Whole thread Raw
In response to Re: Postgres on VPS - how much is enough?  ("Matthew Nuzum" <mattnuzum@gmail.com>)
List 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.
>

pgsql-performance by date:

Previous
From: "Joost Kraaijeveld"
Date:
Subject: Can anyone explain this pgbench results?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Postgres on VPS - how much is enough?