RE: DB Getting Slower and Slower and Slower....
От | Othman Laraki |
---|---|
Тема | RE: DB Getting Slower and Slower and Slower.... |
Дата | |
Msg-id | GBEGLFJBEMGPPFJEFJNAGEJACJAA.othman@epitrope.com обсуждение исходный текст |
Ответ на | Re: DB Getting Slower and Slower and Slower.... ("Mitch Vincent" <mitch@venux.net>) |
Список | pgsql-general |
Yup -----Original Message----- From: Mitch Vincent [mailto:mitch@venux.net] Sent: Thursday, May 03, 2001 8:59 PM To: Othman Laraki; pgsql-general@postgresql.org Subject: Re: DB Getting Slower and Slower and Slower.... Do you VACUUM and VACUUM ANALYZE regularly? -Mitch ----- Original Message ----- From: "Othman Laraki" <othman@epitrope.com> To: <pgsql-general@postgresql.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@epitrope.com > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-general по дате отправления: