Re: Cluster and vacuum performance

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Shea,Dan [CIS]" <Dan(dot)Shea(at)ec(dot)gc(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Cluster and vacuum performance
Date: 2004-03-09 22:20:53
Message-ID: 200403091420.53924.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-03-09 22:57:36 Re: Cluster and vacuum performance
Previous Message Richard Huxton 2004-03-09 21:34:35 Re: [PERFORM] syslog slowing the database?