0

I automatically run a script that performs a FULL VACUUM on my Posrtgresql databases but today it crashed because the process was blocked (surely by another operation on the table).

I want to make sure that he ignores the tables on which there is already a lock, how to do?

Thank you

  • `VACUUM (FULL)` normally doesn't crash if encounters a lock, so maybe you should explain that in more detail. Are you sure you need `VACUUM (FULL)` regularly? – Laurenz Albe Nov 30 '17 at 19:24
  • Yes, once a week. I do : `acuum FULL VERBOSE ANALYZE; reindex database postgres;` –  Dec 01 '17 at 10:25

0 Answers0