Opened 13 years ago
Last modified 7 years ago
#1124 new enhancement
shp2pgsql, shp2pgsql-gui switch to create unlogged table
| Reported by: | robe | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS Fund Me |
| Component: | postgis | Version: | master |
| Keywords: | Cc: |
Description
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.
Note:
See TracTickets
for help on using tickets.
hmm not sure if GIST indexes are supported yet on unlogged tables though so might not be quite as useful as it could be. I'll be experimenting with it in my 9.1beta3 build