Alvaro Herrera <[EMAIL PROTECTED]> writes: > A quickie: this item > Store only active XIDs in subtransaction cache > was already done:
I think Bruce is referring to the idea that you and I each arrived at recently, ie removing subcommitted subxact XIDs from the PGPROC cache if they hadn't stored any tuples. That certainly wasn't done by my commit you mention ... did you do it when I wasn't looking? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match