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

[Frederik Ramm]

Hi,

On 06/18/2012 09:43 PM, Lynn W. Deffenbaugh (Mr) wrote:
> for a total of just under 88GB so a 120GB SSD should do the job. Now, to
> see if I can figure out how to split up the DB to assign different
> tables to different places....

Attach, format (ext4) and mount (-o discard) the SSD; make sure it is 
owned by the postgresql user; in psql, enter "create tablespace ssd 
location '/where/i/mounted/the/ssd'", then "alter tablespace ssd owner 
to osm" (or whatever account you use for running osm2pgsql), then "alter 
table table_i_want_to_move tablespace ssd". You might also have to 
"alter index... tablespace ssd" for the associated indexes. A "pg_dump 
--schema-only" will tell you what is in which tablespace should you get 
confused.

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"