culley <culley@easystreet.com> writes:
> couple of questions about vacuum:
>
> If you run vacuum nightly does that mean you do not need to run vacuum
> analyze? is analyze implicit?
No. Running VACUUM ANALYZE will do everything needed, though (VACUUM
is implicit in VACUUM ANALYZE).
> I've set up a job to vacuum my databases nightly but the account
> running the job doesn't have super-user permissions and it blows up on
> all the pg_ tables. Is there any harm in transferring ownership of
> these tables away from a super-user?
It would be much better to run the VACUUM job as the PG superuser or
an account with superuser privs. I would think changing perms on pg_*
could lead to severe security holes.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
