[OSM-dev] osm2pgsql slim mode, postgis, and hard disk spindles

[Frederik Ramm]

Hi,

Lennard wrote:
>> But given the way osm2pgsql works in "slim" mode, I wonder whether it 
>> might perhaps make sense to put the node/way/relation tables on one hard 
>> disk, and the tables with geometries (planetosm_line etc.) on the other?
> 
> Given that, AFAIK, all tables/indexes are in 1 directory, how will you 
> make that distinction?

You can CREATE TABLESPACE on different harddisks and then when creating 
the table or index you can specify which tablespace it should be created 
in. You can also move an existing table to another tablespace (ALTER 
TABLE MOVE TABLESPACE) but this kills the indexes. For reliable 
operation, osm2pgsql would probably have to be patched to allow creating 
of different tables in different tablespaces but that's just a minor 
addition to the CREATE TABLE/CREATE INDEX.

Bye
Frederik