Re: Vacuum Questions

2025-05-05 Thread Craig Jackson
One additional point about reindexing I should have mentioned, make sure you have adequate disk space to complete the reindexing. Craig On Mon, May 5, 2025 at 8:33 AM Craig Jackson wrote: > For the two indexes that take 12 hours to vacuum: If you can drop and > rebuild them in less than the 12

Re: Vacuum Questions

2025-05-05 Thread Craig Jackson
For the two indexes that take 12 hours to vacuum: If you can drop and rebuild them in less than the 12 hours it takes to vacuum them and you can have them be offline then I would do that. If you can't take the indexes offline then consider reindexing online. Also, if the indexes aren't needed for