Opened 14 years ago

Closed 14 years ago

Last modified 5 years 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 by jorgearevalo, 14 years ago

Resolution: fixed
Status: newclosed

Fixed in r5542

comment:2 by Raul Marin, 5 years ago

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.