Hello!
Can I execute VACUUM ANALYZE from ecpg?
How I do that???
/* I do: EXEC SQL VACUUM ANALYZE <table>; But I get error: 'ERROR: VACUUM cannot run inside a transaction block'
*/
Turn on/off autocommit maybe? Or fake it with "EXEC SQL COMMIT; VACUUM ANALYZE" ? :)
Magnus
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
