Re: Postgres on VPS - how much is enough?

Поиск
Список
Период
Сортировка
От Nagita Karunaratne
Тема Re: Postgres on VPS - how much is enough?
Дата
Msg-id b2990fb00603060852l6e6f02b7n6a8c3bfe81cf7f6a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres on VPS - how much is enough?  ("Matthew Nuzum" <mattnuzum@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Joost Kraaijeveld"
Дата:
Сообщение: Can anyone explain this pgbench results?
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Postgres on VPS - how much is enough?