Обсуждение: DB Getting Slower and Slower and Slower....

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


_____________________________
Othman Laraki
Epitrope Corporation
860 Hillview Court, Suite 200
Milpitas, CA 95035, USA
650-814-9580 (phone)
650-745-2449 (fax)
othman@epitrope.com

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