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

Hi,

We have an application running the same Java-tomcat on Apache running
on Oracle DB. We have a max of 3 users per second connection on it and
you now what, we have to restart the Apache daemon at 12 and 22 hours
each days.

For me the problem is not relative to the database but only to Java. Take
a look at your memory you will see that it goes were we don't know.

So now we don't use Java anymore. Perl and Mod_perl as the same perf
and it's stable.

Regards

Gilles DAROLD

Mitch Vincent wrote:

> 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
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html