Обсуждение: VACUUM analyze verbose is skipping tables

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

"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