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
