PDA

View Full Version : Unable to vacuum analyze database



baggin
10-12-2008, 01:49 PM
Hi,

Bought HEM about a week ago and have been putting a huge amount of hands into it.

As I understand, it is smart to vacuum analyze the database from time to time, to clean things up and make it run good.

I am trying to do this for the first time now, but get the following message:

"There was an error during the Vacuum. Please manually vacuum your database through pgadmin"

Why this error and what can I do?

morny
10-12-2008, 02:41 PM
http://208.109.95.123/faq/afmviewfaq.aspx?faqid=163

baggin
10-13-2008, 03:32 AM
Ok, thanks. I will try this.

1.) Why do I have to do it manually?

2.) What are the benefits of doing this vacuuming? And how often should it be done?

morny
10-13-2008, 12:24 PM
1) Its integrated into the HM software to auto run it to save you doing all those steps in the manual version however for a reason we havent figured out yet a small minority cant run it so it must be done manually

2) It reorgainses the tables and data to imprve the speed queries are run which obviously makes reports run quicker

baggin
10-14-2008, 02:41 AM
Ok, thanks.