Skip site navigation (1) Skip section navigation (2)

Re: postgres eating CPU on HP9000

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marcus Andree S(dot) Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br>
Cc: josh(at)agliodbs(dot)com, scott(dot)marlowe(at)ihs(dot)com,nfesposi(at)sourceweave(dot)net, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres eating CPU on HP9000
Date: 2004-03-29 15:36:37
Message-ID: 1117.1080574597@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"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

Responses

pgsql-performance by date

Next:From: Fabio EspositoDate: 2004-03-29 17:00:16
Subject: Re: postgres eating CPU on HP9000
Previous:From: Fabio EspositoDate: 2004-03-29 13:09:22
Subject: Re: postgres eating CPU on HP9000

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group