Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM analyze verbose is skipping tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: VACUUM analyze verbose is skipping tables
Date
Msg-id 6798.1088722126@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM analyze verbose is skipping tables  ("Lending, Rune" <rune.lending@inpoc.com>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: Roberto João Lopes Garcia
Date:
Subject: string concatenator || and NULL values
Next
From: Bruno Wolff III
Date:
Subject: Re: string concatenator || and NULL values