> > Interestingly though, when the range in the generate_series() was > > small enough to fit in 4 bytes of memory (e.g. > > generate_series(1,1000000000) ), the above query completed consuming > > only negligible amount of memory. So, it looked like the aggregate > > computation was being pipelined with the tuples returned from > > generate_series(). > > It's pipelined either way. But int8 is a pass-by-reference data type, > and it sounds like we have a memory leak for this case. Thanks for your reply. How easy is it to fix this? Which portion of the code should we look to change? - John ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly