From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Ron Marom <ron(at)bitband(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgresql performace degrading after a while |
Date: | 2006-01-30 07:16:55 |
Message-ID: | 20060130071655.GA26388@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jan 30, 2006 at 09:02:24AM +0200, Ron Marom wrote:
> I seem to have a problem with postgresql 7.4.2 running on Red Hat
> Enterprise Linux ES3.
If you can't upgrade to 8.0 or 8.1 then at least consider using the
latest version in the 7.4 branch (7.4.11). You're missing almost
two years of bug fixes.
http://www.postgresql.org/docs/7.4/static/release.html
> I am running an application server over a database in which tables
> contains at most a few thousands of records. The problematic table,
> however, contains 67 records, with an application daemon updating
> all those records every 30 seconds.
Are you vacuuming that table frequently? If not then it's accumulating
a lot of dead tuples, which would cause performance to degrade.
Are you vacuuming at all? See "Routine Database Maintenance Tasks"
in the documentation for an explanation of what it is and why it's
necessary.
http://www.postgresql.org/docs/7.4/static/maintenance.html
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Marom | 2006-01-30 07:28:14 | Re: postgresql performace degrading after a while |
Previous Message | Ron Marom | 2006-01-30 07:02:24 | postgresql performace degrading after a while |