[OSM-dev] Table/Index Access (for SSD)

[Lynn W. Deffenbaugh (Mr)]

Greetings,

Has anyone done any work on which tables and/or indices are most 
effectively targeted at SSD media for those of us that can't afford 
enough space to hold the entire global DB for osmpgsql/renderd/mod_tile 
updates and access?

My current DB is just under 300GB (yes, it needs a VACUUM), and I'm 
trying to figure out if 120GB or 240GB worth of SSD could be employed 
for selected tables to improve diff application as well as rendering 
performance, primarily the latter.

Lynn (D) - KJ4ERJ