From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "Othman Laraki" <othman(at)epitrope(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DB Getting Slower and Slower and Slower.... |
Date: | 2001-05-04 03:59:10 |
Message-ID: | 01eb01c0d44e$9323abe0$1251000a@windows |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Do you VACUUM and VACUUM ANALYZE regularly?
-Mitch
----- Original Message -----
From: "Othman Laraki" <othman(at)epitrope(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, May 03, 2001 11:59 PM
Subject: 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(at)epitrope(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Othman Laraki | 2001-05-04 03:59:43 | DB Getting Slower and Slower and Slower.... |
Previous Message | Othman Laraki | 2001-05-04 03:54:14 | Can't get Postgres to use indices |