Markus Schaber wrote:
I just asked myself whether a 2-phase-commit transaction that was prepared, but never committed, can block vacuuming and TID recycling.
Yes. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(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