"Luke Lonergan" <llonergan(at)greenplum(dot)com> writes:> Two passes is the state-of-the-practice on external disk sorts.
There is no such thing as a fixed number of passes regardless ofavailable memory and size of the data.
regards, tom lane