Re: Sort memory not being released - Mailing list pgsql-general

From Tom Lane
Subject Re: Sort memory not being released
Date
Msg-id 2641.1055772782@sss.pgh.pa.us
Whole thread Raw
In response to Sort memory not being released  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Sort memory not being released  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-general
"Jim C. Nasby" <jim@nasby.net> writes:
> It appears that after a pgsql backend uses memory for sort, it doesn't
> get released again, at least on solaris. IE:

That's true on many Unixen --- malloc'd space is never released back to
the OS until the process dies.  Not much we can do about it.  If you're
concerned, start a fresh session, or use another Unix (or at least a
better malloc package).

            regards, tom lane

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: Why can't you define a table alias on an update?
Next
From: Mike Mascari
Date:
Subject: Re: RE : full featured alter table?