[postgis-devel] [PostGIS] #499: [wktraster] -M vacuum switch of gdal2wktraster doesn't work with schemas

PostGIS trac at osgeo.org
Tue Apr 13 22:45:08 PDT 2010


#499: [wktraster] -M vacuum switch of gdal2wktraster doesn't work with schemas
-----------------------+----------------------------------------------------
 Reporter:  robe       |       Owner:  pracine        
     Type:  defect     |      Status:  new            
 Priority:  medium     |   Milestone:  WKTRaster 0.1.6
Component:  wktraster  |     Version:  trunk          
 Keywords:             |  
-----------------------+----------------------------------------------------
 If I pass in a schema -- it generates sql that looks something like this

 VACUUM FULL ANALYZE "myschema.mytable";

 Which gives a table does not exist when run.

 Should generate

 "myschema"."mytable"

 Also it shouldn't be doing a vacuum full.  It should just be doing a

 vacuum analyze

 I think there has been talk of deprecating full or replacing it with
 something else since its a performance hog and doesn't really provide that
 much benefit above regular vacuum analyze especially if you are loading
 new tables like this since you don't have dead tuples that need
 reclaiming. You could probably even do fine with just analyze.

 See below for example
 http://it.toolbox.com/blogs/database-soup/getting-rid-of-vacuum-full-
 feedback-needed-33959

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/499>
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.


More information about the postgis-devel mailing list