sort mem size
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 dont 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
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