[Babase] Is Vacuum working?

kfenn kfenn at princeton.edu
Tue Feb 5 10:32:53 EST 2008


Karl O. Pinc wrote:
> It's working, but I don't have it set to run automatically.  Running
> automatically won't make it do what you wany anyway because that
> only means that it runs when it thinks things have changed enough
> that it needs to run.
>
> To get the row counts to change you need to do "VACUUM ANALYZE",
> (PPA has a checkbox).  I believe you need to be the admin to do
> this but I could be wrong.
>
OK, yes the admin account worked.  I was using the ANALYZE before but it 
didn't work in my account.

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list