Re: DB Getting Slower and Slower and Slower....

From: Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>
To: Othman Laraki <othman(at)epitrope(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: DB Getting Slower and Slower and Slower....
Date: 2001-05-07 14:20:46
Message-ID: Pine.LNX.4.30.0105071718080.3453-100000@sorkka.cs.Helsinki.FI
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2 May 2001, Othman Laraki wrote:

> Hi,
> I recently upgraded to V7.1 version of Postgres on Linux and have noticed
> that as the DB is being used, it gets progressively slower and slower, until
> very simple queries slow down to a crawl. The basic setup I have is a set of
> JSPs and Servlets running on Tomcat, that use Java classes which connect to
> Postgres through a JDBC driver and perform various DB operations. But, as I
> said, the DB gets noticeably slower, as if it does not clean up behind
> itself after performing operations and finally runs out of memory... Then,
> the only thing that works is stopping the postmaster and rebooting the
> machine.
>
> If you have any ideas of what may cause this or what I can do to explore
> the issue, I would be very grateful. I am fairly new to Postgres, so any
> suggestions are welcome.
>
> Thanks,
> Othman
>
Are you using VACUUM ANLYZE periodically? Does the postmaster process
bloat? The backend processes (postgres) are created for each connection.
Does their size increase?

- Einar Karttunen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2001-05-07 14:23:05 Re: subtratcing dates
Previous Message Justin Clift 2001-05-07 13:58:00 Re: PostgreSQL vs. Interbase