I've tried to run a VACUUM SORT on a massive table for several weekends now, starting them Friday night and praying that they finish by Monday morning, but every time have had to kill it, because it hasn't finished! I was hoping that the progress of everything done during those 2 and a half days would carry over, so that eventually, one weekend would be enough to finish a VACUUM.

I've seen posts about PostgreSQL and how all the progress gets lost on VACUUM FULL jobs unless the VACUUM finishes entirely, but they are either quite old, or I'm thinking different enough from Redshift that this post is warranted. Thank you in advance for any and all assistance!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.