Advertisement

05.15.2008 at 02:36AM PDT, ID: 23404382
[x]
Attachment Details

Why PostgreSQL uses more and more server memory?

Asked by drazen_nikolic in PostgreSQL Database, Linux, Application Servers

Tags: PostgreSQL, JAVA

We have PostgreSQL 8.1.9 on Linux (CentOS 5) and a web JAVA application running on Apache Tomcat server using the database (on the same machine). What we saw is that server free memory is from day to day decreasing. We saw that postgres processes cumulatively occupies more and more memory. And in few days all memory is occupied and server stops responding.

Do you have any idea why this happens? Will migrating to PostgreSQL 8.3 version maybe be of some help on this issue?

Any idea/hint is appreciated. Thank you.Start Free Trial
[+][-]05.15.2008 at 03:10AM PDT, ID: 21571963

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PostgreSQL Database, Linux, Application Servers
Tags: PostgreSQL, JAVA
Sign Up Now!
Solution Provided By: uetian1707
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.16.2008 at 08:01AM PDT, ID: 21583336

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628