Opened 11 years ago

Closed 11 years ago

Last modified 12 months ago

#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

Change History (2)

comment:1 Changed 11 years ago by jorgearevalo

Resolution: fixed
Status: newclosed

Fixed in r5542

comment:2 Changed 12 months ago by Raul Marin

In 17951:

Use get_call_result_type to retrieve tuple descriptions

Closes #499
References #4549
References #4546

Note: See TracTickets for help on using tickets.