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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match