Re: Sort memory not being released

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jim(at)nasby(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sort memory not being released
Date: 2003-06-18 00:08:29
Message-ID: 17918.1055894909@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general

"Jim C. Nasby" <jim(at)nasby(dot)net> writes:
> Well, there's other ways to do what I'm thinking of that don't rely on
> getting a free memory number from the OS. For example, there could be a
> 'total_sort_mem' parameter that specifies the total amount of memory
> that can be used for all sorts on the entire machine.

How would you find out how many other sorts are going on (and how much
memory they're actually using)? And probably more to the point, what do
you do if you want to sort and the parameter's already exhausted?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-18 00:12:18 Re: [PERFORM] Interesting incosistent query timing
Previous Message Tom Lane 2003-06-17 23:29:16 Re: order of nested loop