PDA

View Full Version : question about vacuum database



HHLWX1
04-30-2013, 11:12 AM
There's an option in the list of tools:vacuum database.I wonder is there any difference from the vacuum we usually do in the pgAdmin.exe?If I do this vacuum in notecaddy,should I do reindex afterwards?

sreticentv
04-30-2013, 11:50 AM
If you are advanced enough to know what pgAdmin is (most people do not) then you should keep using that. NC doesn't do a reindex or analyze

rowhousepd
08-31-2015, 07:20 PM
Is there a difference between vacuuming via NoteCaddy > Tools > Vacuum and doing it through the Database window in HM2? I usually run the "Full - Vacuum" option that way every week or so. Does that do the same thing at the NC version? Thanks.

sreticentv
09-01-2015, 02:39 PM
I am not sure what HM2 does in their window but NC does run a vacuum full command on postgres

rowhousepd
09-01-2015, 05:24 PM
I am not sure what HM2 does in their window but NC does run a vacuum full command on postgres

Ok, I'll ask one of the other HM folks. Thanks. :)