Re: Need help understanding vacuum verbose output

From: Gordon Shannon <gordo169(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help understanding vacuum verbose output
Date: 2010-08-06 15:45:10
Message-ID: 1281109510538-2266792.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


OK, so if it knew that all vacuumable tuples could be found in 492 pages, and
it scanned only those pages, then how could it be that it reports 16558
removable tuples from those 492 pages, when it has already reported earlier
that it removed 45878 tuples -- a number we know in fact to be correct? How
could both statements be correct?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Need-help-understanding-vacuum-verbose-output-tp2265895p2266792.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-08-06 15:45:16 Re: MySQL versus Postgres
Previous Message John Gage 2010-08-06 15:44:04 Re: MySQL versus Postgres