Hi, I just have a question about vacuuming indexes.
So I start to vacuum a set of indexes for say "User" and then they are flagged as deleting. If I was to run another vacuum for say "Game" while the User indexes are still deleting, is it possible that I could confuse the workers and the indexes end up in error state?
I ask this because it was either a pure coincidence, a quoter could have been reached over night, or it could be the fact that you can't vacuum again while other indexes are deleting. I suppose what I'm really asking is: What goes on under the hood when indexes are being deleted... Does running another vacuum then deleting further indexes interrupt ones that are being focused on by the workers first?
Thank you in advance for any help or suggestions,
Mark