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 [email protected] ## N49°00'09" E008°23'33" _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
