Re: [PLUG] VPS Recommendation

[Morgan Jones <morgan@morganjones.org>]

I am not a database expert by any stretch but isn't there an optimization option that could make better use of system memory rather than depend on fast back-end storage?  

In particular depending on how the data is accessed could you cache, say, in 2-3gb of RAM and those use a 4gb VPS or similar?  That may still not be reasonably priced with Linode but at least it's a less specialized hosting service and you could shop it around a little more.

-morgan



On May 11, 2012, at 11:46 AM, brainbuz@brainbuz.org wrote:

> I love Linode, but there is one thing I want that they don't offer: SSD
> backed storage.
> 
> I have an 8GB postgres database used for lookups only. For performance
> this database should be on a tablespace on an SSD.
> 
> Any recommendations (other than continuing to host a production server at
> my house with consumer fios) for an alternative?
> 
> ___________________________________________________________________________
> Philadelphia Linux Users Group         --        http://www.phillylinux.org
> Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug