DB Getting Slower and Slower and Slower....

From: "Othman Laraki" <othman(at)epitrope(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: DB Getting Slower and Slower and Slower....
Date: 2001-05-03 02:17:49
Message-ID: GBEGLFJBEMGPPFJEFJNAEEIDCJAA.othman@epitrope.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)epitrope(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message GH 2001-05-03 02:29:09 Re: Unique or Primary Key?
Previous Message Tom Lane 2001-05-03 02:15:23 Re: View permissions in 7.1