Simon Riggs <[EMAIL PROTECTED]> writes: > There is a noticeable rise in sort time with increasing work_mem, but > that needs to be offset from the benefit that in-general comes from > using a large Heap for the sort. With the data you're using that always > looks like a loss, but that isn't true with all input data orderings.
Yeah, these are all the exact same test data, right? We need a bit more variety in the test cases before drawing any sweeping conclusions. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly