"Vince Negri" <vnegri@xxxxxxxxxxxxxxxxxxxxx> writes:
> What causes the file handles of the truncated table to be released by all postmaster processes?
It should happen when the other backends process the sinval message
about the TRUNCATE, which at the latest should be the next time they
begin command execution. What were the other clients doing, just
sitting idle?
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
