implicit analyze on vacuum?

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