K C Lau <kclau60@xxxxxxxxxxxxxx> writes: > Without knowing the internals, I have this simplistic idea: if Postgres > maintains the current lowest transaction ID for all active transactions, it > probably could recycle dead tuples on the fly. [ yawn... ] Yes, we've heard that before. The hard part is getting rid of index entries. regards, tom lane