VACUUM analyze verbose is skipping tables
Started by Lending, Runealmost 22 years ago2 messagesbugs
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
"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