On Feb 21, 2007, at 12:58 AM, Stefan Kaltenbrunner wrote:
Have you actually measured a performance improvment going beyond 250-350MB(that seemed about to be the sweet spot last I tested) or so for index creation and friends ?
To be honest, no; I just set it high to play on the safe side. But I have seen reports of large in-memory sorts actually being slower than tape sorts in some cases, so I probably am leaving some performance on the table.
-- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
