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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
