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@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)