new tablespace parameter for shp2pgsql

[kneufeld]

I would like to see the addition of a tablespace parameter added to shp2pgsql.

For loading large tables, this is currently a three stage process.

• load DDL from shp2pgsql
• use psql and alter the tablespace of the table
• load the data from shp2pgsql

Postgres stores relations as individual files. When loading several thousand tables, the underlying OS can become slow when looking up a particular file/table. Having multiple tablespaces solves this problem.

[mcayland]

I guess that could be a useful feature; as a temporary work-around you could always use ALTER USER foo SET default_tablespace 'bar' and then load the shp2pgsql output as the foo user before reverting if required.

ATB,

Mark.

[robe]

Wouldn't this be considered an API change in which case it should go to 1.5

[mcayland]

+1 for saving until 1.5. Otherwise we fall back into the same trap of having feature changes in point release.

ATB,

Mark.

[pramsey]

Rolling this forward

[jadams]

Implemented on trunk, rev 6905.

You specify the tablespace for the table and the indexes (primary key and spatial index if -I is specified) separately:

-T <table tablespace>

and/or

-X <index tablespace>