[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