#499 closed defect (fixed)
[wktraster] -M vacuum switch of gdal2wktraster doesn't work with schemas
Reported by: | robe | Owned by: | pracine |
---|---|---|---|
Priority: | medium | Milestone: | WKTRaster 0.1.6 |
Component: | raster | Version: | master |
Keywords: | Cc: |
Description
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
Fixed in r5542