Horton

Re: Idea about better configuration options for sort memory

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jeff <threshar@torgo.978.org>, "Marc G. Fournier" <scrappy@postgresql.org>, pgsql-hackers@postgresql.org
Date: 2004-02-03T16:12:49Z
Lists: pgsql-hackers 
scott.marlowe wrote:
> On Mon, 2 Feb 2004, Tom Lane wrote:
> 
> > "scott.marlowe" <scott.marlowe@ihs.com> writes:
> > > any chance of having some kind of max_total_sort_mem setting to keep 
> > > machines out of swap storms, or would that be a nightmare to implement?
> > 
> > I don't see any reasonable way to do that.
> 
> I didn't think there was.  just hoping... :-)

Someone asked for this in Copenhagen, and I said we can't see how to do
it.  The only idea I had as to give the first requestor 50% of the
total, then a second query 50% of the remaining memory.  Is that better
than what we have?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073