[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] sort mem size
From:       Bruce Momjian <pgman () candle ! pha ! pa ! us>
Date:       2002-02-28 4:11:49
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]