Forum OpenACS CMS: Re: vacuum is screwing up

Collapse
5: Re: vacuum is screwing up (response to 1)
Posted by Don Baccus on 07/31/03 12:45 AM
The plan is identical, the increase in cost is probably due to the fact that the table increased in size since the previous vacuum.

vacuum statistics are a snapshot - those stats don't change when you add or delete data.

Collapse
7: Re: vacuum is screwing up (response to 5)
Posted by Alpesh Shah on 07/31/03 08:44 AM
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.