Re: Sort memory not being released

On Mon, Jun 16, 2003 at 10:13:02AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jim(at)nasby(dot)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).

Holy ugly batman...

This is on solaris; is there a different/better malloc I could use?

Also, would doing the sort in a seperate process solve the problem? IE:
doing a 'blocking fork()' on entry to the sort routine? (Sorry, I'm not
a C coder...)
--
Jim C. Nasby (aka Decibel!) jim(at)nasby(dot)net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"