| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Együd Csaba <csegyud(at)vnet(dot)hu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps |
| Date: | 2005-06-13 20:50:45 |
| Message-ID: | 20050613205045.GB1346@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-06-13 20:56:08 | Re: Index problem |
| Previous Message | Tom Lane | 2005-06-13 20:45:03 | Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps |