Re: postgres eating CPU on HP9000 - Mailing list pgsql-performance

On Mar 29, 2004, at 9:36 AM, Tom Lane wrote:

> "Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br> writes:
>>> Also do you run VACUUM ANALYZE as a superuser, or as a regular user?
>
>> As a regular user (database owner). Is thery any difference when
>> vacuuming
>> as a super user?
>
> That's your problem.  A regular user won't have permissions to vacuum
> any tables but his own ... in particular, not the system tables.
>
>             regards, tom lane

If I vacuum as the superuser, are the system tables automatically
vacuumed?  Or, does using -a from the vacuumdb command accomplish this?
  Or, is there something else I have to specify on the vacuumdb command
line?

Thanks!
Mark