Forum OpenACS CMS: Re: vacuum is screwing up

Collapse
7: Re: vacuum is screwing up (response to 5)
Posted by Alpesh Shah on
Thanks for reply Don.

Actually I stopped my server before doing vacuum so no entry or delete was happened. So the table size was not changed. Also I can say that the statistics were changed after vacuum as it gave me higher cost after vacuum. I fired explain query and took screenshot then did vacuum and then again fired explain query. So this means whatever changes I got were due to vacuum query. Also the vacuum finished without any error.