"Shea,Dan [CIS]" <[EMAIL PROTECTED]> writes:
> How can you improve the performance of cluster?
> 1. BY increasing sort_mem?
Yes.
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose
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 pro
