Postgres Pro
Downloads
Home   >   mailing lists

Re: Repeated VACUUM reports same number of deleted rows - Mailing list pgsql-general

From Tom Lane
Subject Re: Repeated VACUUM reports same number of deleted rows
Date
Msg-id 9384.1096641729@sss.pgh.pa.us
Whole thread Raw
In response to Repeated VACUUM reports same number of deleted rows  (Russell Smith <mr-russ@pws.com.au>)
Responses Re: Repeated VACUUM reports same number of deleted rows  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-general
Tree view 
Russell Smith <mr-russ@pws.com.au> writes:
> Should VACUUM report the rows as deleted or say they could not be deleted?
> Why does it report the same information for three runs in a row?

I see no pending deletions in that vacuum output:

> DETAIL:  0 dead row versions cannot be removed yet.

so I'm not sure why you would expect the output to change.

            regards, tom lane

pgsql-general by date:

Previous
From: Kevin Barnard
Date:
Subject: Re: newby question
Next
From: Tom Lane
Date:
Subject: Re: Bug with updateable Views and inherited tables?