Michael Crozier wrote:
I think I see now, "dead" tuples are the tuples that have yet to be
reclaimed
by vacuum, not tuples that are ready to be used. I'm still rather
confused,
as this table is only modified via inserts. No deletes or update
operations
are ever performed. Logically (ie "I don't really know the truth")
this
table should have no free tuples or free space except for the
remainder of
the last allocated page.
I suspect that if a transaction rolls back, any inserts done in the
interim turn into dead tuples.
- John Burger
MITRE
---------------------------(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
