Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group