Thread: VACUUM analyze verbose is skipping tables

VACUUM analyze verbose is skipping tables

From
"Lending, Rune"
Date:
Hello.

We are having a big database with a lot of tables. We are running daily
vacuum analyze vith the vacuumdb script.
The problem is that the script is skipping skipping some tables that really
should have been vacuumed.
Does anybody know why this is happening ?

Thanx in advance

Rune

Re: VACUUM analyze verbose is skipping tables

From
Tom Lane
Date:
"Lending, Rune" <rune.lending@inpoc.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