[OSM-dev] Table/Index Access (for SSD)
frederik at remote.org
Tue Jun 19 13:39:31 BST 2012
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
Frederik Ramm ## eMail frederik at remote.org ## N49°00'09" E008°23'33"
More information about the dev