Re: Idea about better configuration options for sort memory

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Joe Conway <mail@joeconway.com>, pgsql-hackers@postgresql.org
Date: 2004-02-01T22:39:35Z
Lists: pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Joe Conway <mail@joeconway.com> writes:
>>> Hmmm ... maybe query_work_mem and maintenance_work_mem, or something 
>>> similar?
>> 
>> I'll go with these unless someone has another proposal ...

> The only confusion is that you can use multiple query_work_mem per
> query, but I can't think of a better name.

True.  Maybe just "work_mem" and "maintenance_work_mem"?

BTW, I am going to look at whether GUC can be persuaded to continue to
allow "sort_mem" as an alternate name, if we rename it.  That would
alleviate most of the backward-compatibility issues of changing such
a well-known parameter name.

			regards, tom lane