Re: Need help understanding vacuum verbose output - Mailing list pgsql-general

From Gordon Shannon
Subject Re: Need help understanding vacuum verbose output
Date
Msg-id 1281109510538-2266792.post@n5.nabble.com
Whole thread Raw
In response to Re: Need help understanding vacuum verbose output  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Need help understanding vacuum verbose output
List 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.

pgsql-general by date:

Previous
From: John Gage
Date:
Subject: Re: MySQL versus Postgres
Next
From: John Gage
Date:
Subject: Re: MySQL versus Postgres