But I need to do full vacuum because I deleted some of the fields that are not use anymore and I also add another fields. Is there
another way to speed up full vacuum?
just make sure that your freespace map is big enough and then do a vacuum analyse without the full option.
I can imagine that database performance might not be as good as it would be after a vacuum full, though I expect that it wouldn't make much difference.
- [PERFORM] VACCUM FULL ANALYZE PROBLEM Michael Ryan S. Puncia
- Re: [PERFORM] VACCUM FULL ANALYZE PROBLEM Iain
- Re: [PERFORM] VACCUM FULL ANALYZE PROBLEM Rod Taylor