Re: Function execution consuming lot of memory and eventually making server unresponsive

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-performance(at)postgresql(dot)org>,<gnanam(at)zoniac(dot)com>
Subject: Re: Function execution consuming lot of memory and eventually making server unresponsive
Date: 2011-02-24 12:29:04
Message-ID: 4D65FAB0020000250003AF7F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Gnanakumar" wrote:

> We're using PostgreSQL v8.2.3 on RHEL5.

http://www.postgresql.org/support/versioning

The 8.2 release is up to 8.2.20:

http://www.postgresql.org/

By the way, 8.2 is scheduled to go out of support later this year:

http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

You might want to start planning to upgrade.

> I'm developing a PostgreSQL plpgsql function for one of our
> application report. When I try to run the function multiple times
> (even twice or thrice), I'm seeing considerable amount of memory
> being taken up by PostgreSQL and thereby after sometime, complete
> server itself comes to standstill and not responding at all, even
> am not able to login to my server using PuTTY client. I then end up
> physically restarting the server.

You might want to review the bug fixes since 8.2.3 and see if any
involve memory leaks:

http://www.postgresql.org/docs/8.2/static/release.html

-Kevin

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-02-24 14:25:19 Re: Unused indices
Previous Message Pavel Stehule 2011-02-24 10:29:28 Re: Function execution consuming lot of memory and eventually making server unresponsive