PDA

View Full Version : Manual vacuum in 8.3



JPFisher55
07-31-2008, 10:34 AM
I tried vacuuming and analyzing the database, but it says to do a manual vacuum. I am using Postgrl 8.3. The manual vacuum instructions for 8.2 do not seem to fit 8.3. So how do I vacuum manually with 8.3?

morny
07-31-2008, 10:41 AM
Ill need to look into this, i dont have 8.3 so i cant do it on this PC, can you send me an email so i can add it to my todo list and a link to this thread and ill reply when i get it done but ill need access to another pc so it might be later today or tommorrow.

agc1976
07-31-2008, 01:03 PM
Start --> Programs --> PostgreSQL 8.3 --> pgAdmin III

On the left hand side, expand the following:
- Servers
- PostgreSQL Database Server 8.3 (local)
- Databases (x)

Select your HM database and right click on it and select MAINTENANCE
Make sure the Vaccum operation is selected and the ANALYZE option is checked below that.

Click OK

JPFisher55
07-31-2008, 03:19 PM
Thank you