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

From Josh Berkus
Subject Re: Cluster and vacuum performance
Date
Msg-id 200403091420.53924.josh@agliodbs.com
Whole thread Raw
In response to Cluster and vacuum performance  ("Shea,Dan [CIS]" <Dan.Shea@ec.gc.ca>)
Responses Re: Cluster and vacuum performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Dan,

> 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.
Look for long-hung processes and/or transaction management errors in your
client code.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: syslog slowing the database?
Next
From: Aaron W
Date:
Subject: Re: Scaling further up