>>>>> "RT" == Robert Treat <[EMAIL PROTECTED]> writes:
RT> hmm... i wonder what would happen if you pushed your sort_mem higher... RT> on some of our development boxes and upgrade scripts, i push the RT> sort_mem to 102400 and sometimes even higher depending on the box. this RT> really speeds up my restores quit a bit (and is generally safe as i make RT> sure there isn't any other activity going on at the time) I was just checking, and I already ran test with larger sort_mem. the checkpoint segments made more of a difference... ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend