Re: Cluster and vacuum performance

Josh Berkus <josh@agliodbs.com> writes:
>> INFO:  vacuuming "public.forecastelement"
>> INFO:  "forecastelement": found 93351479 removable, 219177133 nonremovable

> The high number of nonremovable above probably indicates that you have a
> transaction being held open which prevents VACUUM from being effective.

You misread it --- "nonremovable" doesn't mean "dead but not removable",
it just means "not removable".  Actually the next line of his log showed
there were zero nonremovable dead tuples, so he's not got any
open-transaction problem.

            regards, tom lane