On Mon, Jun 13, 2005 at 22:27:31 +0200,
Együd Csaba <csegyud(at)vnet(dot)hu> wrote:
>
> The critical tables are vacuum analyzed in every hour. (Not vacuum full
> because of the several minutes long exclusive lock)
>
> Earlier the system had been running for 3 months without problems, but a few
> weeks ago suddenly it got slower and slower. By now I have to vacuum full
> analyze the whole database almost every day to achieve the requested
> performance.
>
> The operating system is a Win2k adv. server, on a HP NetServer LC2000
> (2xPIII1GHz + 2x36GB SCSI RAID1; 1GB RAM)
>
> I know that Windows is blame... etc., but what about that 3 months perfect
> runtime?
>
> What could cause this issue?
Is your FSM setting high enough?