Am Dienstag, 11. Juli 2006 23:01 schrieb Alvaro Herrera: > One exception is that we can't do that with full vacuums. The reason is > that full vacuum may want to run user-defined functions to be able to > index the tuples it moves. This isn't a problem normally, except in the > case where the function tries to scan some other table: if we ignored > that transaction, then another lazy vacuum might delete tuples from that > table that we need to see.
Functions in the index expression must be immutable, so I don't think that is a real concern. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend