Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: postgres eating CPU on HP9000
Date
Msg-id 1117.1080574597@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres eating CPU on HP9000  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Responses Re: postgres eating CPU on HP9000
Re: postgres eating CPU on HP9000
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: Fabio Esposito
Date:
Subject: Re: postgres eating CPU on HP9000
Next
From: Fabio Esposito
Date:
Subject: Re: postgres eating CPU on HP9000