On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:And now you know why they are so good if you don't use all rows. This benefit I think goes away if you use Joe Conway's suggestion of WITH HOLD.
Okay, so WITH HOLD is actually materializing the entire resultset (sequential scan or otherwise)? If that's true, you're right, some of the benefits do go away.
Keep in mind that the tuplestore stays in memory as long as it fits within sort_mem kilobytes. And you can do:
set sort_mem to <some_large_number>;
prior to COMMIT, and then
set sort_mem to default;
after COMMIT, as long as you can afford the memory use. A bit ugly, but it might come in handy ;-)
Joe
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
