On Sat, 2 Oct 2004 12:42 am, Tom Lane wrote:
> Russell Smith <[EMAIL PROTECTED]> 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.
> 
INFO:  vacuuming "filter.access_log_big"
INFO:  index "access_log_url" now contains 5159204 row versions in 74984 pages
DETAIL:  21455 index pages have been deleted, 20000 are currently reusable.

I expect that index info not to be the same each vacuum run.  Why are 21455 index 
pages deleted
on runs 1, 2 and 3.

> so I'm not sure why you would expect the output to change.
> 
>    regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 
> 

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to