[postgis-devel] [PostGIS] #67: new tablespace parameter for shp2pgsql
PostGIS
trac at osgeo.org
Mon Jun 22 17:10:03 PDT 2009
#67: new tablespace parameter for shp2pgsql
--------------------------+-------------------------------------------------
Reporter: kneufeld | Owner: kneufeld
Type: enhancement | Status: assigned
Priority: medium | Milestone: postgis 1.4.1
Component: postgis | Version: trunk
Resolution: accepted | Keywords:
--------------------------+-------------------------------------------------
Changes (by pramsey):
* version: => trunk
* milestone: => postgis 1.4.1
Old 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.
New 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.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/67#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS
More information about the postgis-devel
mailing list