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. > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
