The executor heartbeat timeout makes sense to investigate first, especially with a table that has grown to around 1.5 crore rows. I’d be interested to know whether increasing executor resources actually resolved the issue before changing the command sequence. Also, does running OPTIMIZE before VACUUM make a noticeable difference for a table of this size?