Thread: sort mem size

sort mem size

From
"David Blood"
Date:

Does any one have a good idea of what the sort memory is best set at.  I have read Bruce suggestions but they are vague and just say make it bigger till you don’t have page ins.  I wonder if there is someone who knows what a good setting is for a Db with tables that are over 700 MB and total DB size of 6GB + ?  The Machine has 2Gb ram with a shrmax setting of  1800000000 about 1.6 gb

Thanks in advance for your help

David

Re: sort mem size

From
Bruce Momjian
Date:
David Blood wrote:
> Does any one have a good idea of what the sort memory is best set at.  I
> have read Bruce suggestions but they are vague and just say make it
> bigger till you don?t have page ins.  I wonder if there is someone who
> knows what a good setting is for a Db with tables that are over 700 MB
> and total DB size of 6GB + ?  The Machine has 2Gb ram with a shrmax
> setting of  1800000000 about 1.6 gb

If there was a simple answer, I would have given one in the article.
Does anyone know a good value?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026