On 9/8/04 9:11 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> FWIW, increasing sort_mem for the reload process would probably help
> with the index and FK rebuilds. (8.0 rejiggers things so that the
> memory constraints for these operations are driven off a separate
> variable, but in 7.* you need to muck about with sort_mem. The
> appropriate value for one-off operations is a lot higher than what
> you would want multiple competing backends to be using.)
How big are we talking? I've got it set to 65535 right now. Multiply it by
10?
Wes