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