Eric Ridge wrote:Is the tuplestore basically just an array of ItemPointer-s? In mean, it's not a copy of each entire row, is it?
Yup, it is copied:
wow. I should go back and read the archives to see if this was discussed already, but I can't help but wonder if there's a way to only copy pointers to the tuples. I realize VACUUM could screw it up, but maybe something could be invented (or re-used) to help guard against that.
eric
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match