Re: Cluster and vacuum performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Cluster and vacuum performance
Date
Msg-id 29780.1078875052@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cluster and vacuum performance  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Cluster and vacuum performance  (Josh Berkus <josh@agliodbs.com>)
List pgsql-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

pgsql-performance by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: [ADMIN] syslog slowing the database?
Next
From: Tom Lane
Date:
Subject: Re: Cluster and vacuum performance