[postgis-devel] [PostGIS] #1124: shp2pgsql, shp2pgsql-gui switch to create unlogged table

[PostGIS]

#1124: shp2pgsql, shp2pgsql-gui switch to create unlogged table
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey       
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  postgis      |     Version:  trunk         
 Keywords:               |  
-------------------------+--------------------------------------------------
 PostgreSQL 9.1 has this very popular feature called unlogged tables.  This
 creates a table that is not WAL logged and results in 2-10 times faster
 load speed.

 This is particularly useful for PostGIS users since a lot of processing
 done involves loading shapefiles into the database and then updating or
 pushing them into other tables.  These stagiing tables do not need to be
 logged since they will usually be thrown away after you are done with
 them.

 Here is a nice article detailing the feature:

 http://www.depesz.com/index.php/2011/01/03/waiting-for-9-1-unlogged-
 tables/

 This would be a fairly trivial change to do in shp2pgsql I think and would
 be a great benefit for PostgreSQL 9.1+ users.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1124>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.