Skip site navigation (1) Skip section navigation (2)

Re: Vacuum Verbose output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Subbiah, Stalin" <SSubbiah(at)netopia(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum Verbose output
Date: 2005-10-31 21:22:59
Message-ID: 19097.1130793779@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Subbiah, Stalin" <SSubbiah(at)netopia(dot)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

In response to

pgsql-admin by date

Next:From: Tomeh, HusamDate: 2005-10-31 22:34:43
Subject: Re: Vacuum Verbose output
Previous:From: Subbiah, StalinDate: 2005-10-31 20:13:27
Subject: Vacuum Verbose output

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group