Heikki Linnakangas <[EMAIL PROTECTED]> writes: > The first solution that occurs to me is to force page splits to choose the > target page so that it's blkno > the original page's blkno during vacuum.
I thought about that too, but don't like it for three reasons: * it encourages index bloat, the more the longer the vacuum runs. Not good, especially if you've got aggressive vacuum cost delay settings. * there's a locking problem with respect to how you turn that behavior on. * there's a failure mode where the behavior doesn't get turned off if vacuum fails partway through. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings