Re: Postgres on VPS - how much is enough?

От

Nagita Karunaratne

Тема

Дата

6 марта 2006 г. в 12:52:51

Msg-id

b2990fb00603060852l6e6f02b7n6a8c3bfe81cf7f6a@mail.gmail.com

обсуждение

Ответ на

Re: Postgres on VPS - how much is enough? (Matthew Nuzum)

Список

pgsql-performance

Дерево обсуждения

Postgres on VPS - how much is enough? "Nagita Karunaratne" <nagita.k@gmail.com> 6 марта 2006 г. в 09:28:01

Re: Postgres on VPS - how much is enough? Kevin <kev@drule.org> 6 марта 2006 г. в 11:23:24

Re: Postgres on VPS - how much is enough? "Matthew Nuzum" <mattnuzum@gmail.com> 6 марта 2006 г. в 10:56:03

Re: Postgres on VPS - how much is enough? "Marc G. Fournier" <scrappy@postgresql.org> 6 марта 2006 г. в 13:14:52

Re: Postgres on VPS - how much is enough? "Jim C. Nasby" <jnasby@pervasive.com> 7 марта 2006 г. в 14:46:02

Re: Postgres on VPS - how much is enough? Dave Page <dpage@vale-housing.co.uk> 7 марта 2006 г. в 16:07:39

Re: Postgres on VPS - how much is enough? "Matthew Nuzum" <mattnuzum@gmail.com> 7 марта 2006 г. в 22:15:59

Re: Postgres on VPS - how much is enough? "Matthew Nuzum" <mattnuzum@gmail.com> 6 марта 2006 г. в 15:45:30

Postgres and Ingres R3 / SAN "Jeremy Haile" <jhaile@fastmail.fm> 6 марта 2006 г. в 15:58:48

Re: Postgres and Ingres R3 / SAN "Jim C. Nasby" <jnasby@pervasive.com> 7 марта 2006 г. в 15:00:24

Re: Postgres and Ingres R3 / SAN Mark Lewis <mark.lewis@mir3.com> 7 марта 2006 г. в 15:20:55

Re: Postgres and Ingres R3 / SAN "Jim C. Nasby" <jnasby@pervasive.com> 7 марта 2006 г. в 15:22:28

Re: Postgres on VPS - how much is enough? "Nagita Karunaratne" <nagita.k@gmail.com> 6 марта 2006 г. в 12:52:51

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

Дата: 6 марта 2006 г. в 11:29:50

Сообщение: Can anyone explain this pgbench results?

Следующее

От: Marc G. Fournier

Дата: 6 марта 2006 г. в 13:14:52

Сообщение: Re: Postgres on VPS - how much is enough?