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