Opened 16 years ago
Last modified 13 years ago
#67 closed enhancement (fixed)
new tablespace parameter for shp2pgsql — at Initial Version
| Reported by: | kneufeld | Owned by: | kneufeld |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.0.0 |
| Component: | postgis | Version: | master |
| Keywords: | Cc: |
Description
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.
Note:
See TracTickets
for help on using tickets.
