Re: [HACKERS] PostgreSQL grows to enormous size.

On Fri, 16 Oct 1998, Ean R . Schuessler wrote:

> I wrote a JDBC based web app that I had been using an older version of
> PostgreSQL and recently updated it to 6.3.2. In my new install PostgreSQL
> will grow to enormous sizes (+100M) and then shrink back down without
> any regard to the intensity of queries hitting it. Oddly, beating the snot
> out of the server with lots of queries does _not_ seem to make the server
> grow. It only shows the behaivior when it is getting hit by real net
> connections. There are several other new elements involved (new libc6, new
> Apache, new JServ, etc) but I am befoggulated by the memory growth of
> PostgreSQL. Running Postmaster with -d 2 doesn't indicate anything
> special when the memory bounces up and down and -d 3 proved too much for
> my tiny brain pan.

I ran a test earlier in the week, and saw a similar problem. It doesn't
look like JDBC's fault, as I got similar results using copy in psql.

I haven't had chance to look at it deeper, as I've been finishing off the
JDBC documentation.

> I am thouroughly confused and don't really know where to start to try
> and debug the problem.

What version of postgresql were you using before you upgraded?

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf