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

From Tom Lane
Subject Re: Sort memory not being released
Date
Msg-id 17918.1055894909@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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:
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: order of nested loop
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Interesting incosistent query timing