drop intermediate table and vacuum analyze as soon as possible to save space