"Marcus Andree S. Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)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
In response to
pgsql-performance by date
|Next:||From: Fabio Esposito||Date: 2004-03-29 17:00:16|
|Subject: Re: postgres eating CPU on HP9000 |
|Previous:||From: Fabio Esposito||Date: 2004-03-29 13:09:22|
|Subject: Re: postgres eating CPU on HP9000|