Re: VACUUM analyze verbose is skipping tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lending, Rune" <rune(dot)lending(at)inpoc(dot)com>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: VACUUM analyze verbose is skipping tables
Date: 2004-07-01 22:48:46
Message-ID: 6798.1088722126@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Lending, Rune" <rune(dot)lending(at)inpoc(dot)com> writes:
> The problem is that the script is skipping skipping some tables that really
> should have been vacuumed.

AFAIR vacuum will only skip tables if (a) you don't own them and (b)
you're not superuser.

The vacuumdb script really should always be run as a Postgres superuser.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2004-07-01 23:02:19 Re: string concatenator || and NULL values
Previous Message Jean-Luc Lachance 2004-07-01 22:16:29 Re: No rows returned from the SQL query (possible bug)