Re: postgres gets slower after some while

From: Harald Fuchs <hf0722x(at)protecting(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres gets slower after some while
Date: 2004-11-02 14:22:16
Message-ID: puoeig72lj.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <41877E56(dot)4060504(at)inbox(dot)lv>,
Edgars <edzix19(at)inbox(dot)lv> writes:

> Jaime,

> thanks for the response!

> yes, i have tried this VACUMM, it gives some effect but only for some
> time (2hours or so). Maybe you know why it is happening so?

PostgreSQL can't run for long without a proper VACUUM policy. Read
the docs under "Routine Database Maintenance Tasks".

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2004-11-02 14:48:06 Re: initlocation -- command not found -- HELP NEEDED
Previous Message Andrei Bintintan 2004-11-02 14:17:07 pg_dump question