Skip to main content
added 122 characters in body
Source Link
Laurenz Albe
  • 56.4k
  • 4
  • 49
  • 82

There can only be a single VACUUM running on a table at any given time. If you start two, the second will be blocked until the first is done. You can safely kill the autovacuum process that is waiting for the lock. On the other hand, if you kill the process, it will come back withing the minute, so you might as well let it hang there.

There can only be a single VACUUM running on a table at any given time. If you start two, the second will be blocked until the first is done. You can safely kill the autovacuum process that is waiting for the lock.

There can only be a single VACUUM running on a table at any given time. If you start two, the second will be blocked until the first is done. You can safely kill the autovacuum process that is waiting for the lock. On the other hand, if you kill the process, it will come back withing the minute, so you might as well let it hang there.

Source Link
Laurenz Albe
  • 56.4k
  • 4
  • 49
  • 82

There can only be a single VACUUM running on a table at any given time. If you start two, the second will be blocked until the first is done. You can safely kill the autovacuum process that is waiting for the lock.