"Subbiah, Stalin" <SSubbiah@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
