[Babase] Is Vacuum working?
Karl O. Pinc
kop at meme.com
Tue Feb 5 09:57:34 EST 2008
On 02/05/2008 07:19:32 AM, kfenn wrote:
> Hi Karl,
>
> Is the vacuum function working is babase and babase_test? Didn't you
> set it to run automatically ...or was that just for individual
> schemas? I like to have it running during updates because I can
> check that the row count is correct after each upload. I tried
> running it manually with the buttons, but the row count still isn't
> changing.
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.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list