| From: | Fabio Esposito <nfesposi(at)sourceweave(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Marcus Andree S(dot) Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br>, <josh(at)agliodbs(dot)com>, <scott(dot)marlowe(at)ihs(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: postgres eating CPU on HP9000 |
| Date: | 2004-03-29 17:00:16 |
| Message-ID: | Pine.LNX.4.44.0403291159220.25287-100000@cr818510-a.basement |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I'm sorry all, when you say regular user as opposed to superuser are you
talking about the user that postgres is installed and running as? Should
this be done as the os's root?
Fabio
On Mon, 29 Mar 2004, Tom Lane wrote:
> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2004-03-29 17:05:00 | Re: column size too large, is this a bug? |
| Previous Message | Tom Lane | 2004-03-29 15:36:37 | Re: postgres eating CPU on HP9000 |