Re: Multiple sorts in a query

On Tue, 2009-05-19 at 22:19 +0200, Zdenek Kotala wrote:
> Chuck McDevitt píše v út 19. 05. 2009 v 09:33 -0700:

> > Solaris default malloc always uses sbrk(), and never ever tried to reduce the sbrk point.
> >
> > If you want a malloc that uses mmap, there is an non-default malloc that does that (libumem or something?)
>
> There are severals memory allocator on Solaris. You can choose what you
> need. See
>
> mapalloc (it uses mmap insted of srbk)
> mtmalloc (optimized fro multi threaded apps)
> mumem_alloc
> watchmalloc
> bsdmalloc
>
> maybe more.
>
> What I heart is that standard malloc is not good, but it is still here
> for compatibility reason with old application which depends on some
> functionality.

Which one is used in the default PostgreSQL build for Solaris? If you
use default malloc, have you tested the others and would you recommend
one in particular?

Which one has Dimitri used in his performance testing?

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support