Re: Vacuum Verbose output

"Subbiah, Stalin" <SSubbiah@netopia.com> writes:
> INFO:  vacuuming "public.eventlog"
> INFO:  index "ix_eventlog_eventtime" now contains 11465395 row versions
> in 77113 pages
> DETAIL:  8737797 index row versions were removed.

> Does it mean ix_eventlog_ index had 11.4mil row versions out of which
> 8.7mil were removed cause of deletes?

No, it says "now contains", ie those are the post-removal statistics.

> 33189 index pages have been deleted, 0 are currently reusable.

> Does it mean out of 77113 index pages, 33189 were deleted?

Yeah --- so almost half the space in the index is free space (more than
half according to the later report).  Possibly you should be vacuuming
this table a bit more often...

> Why does index and table INFO reported twice with different row version
> numbers on a vacuum run.

Because it had to do two passes of row removal, due to not having enough
vacuum_mem to remember all the dead rows at once.

            regards, tom lane