Hi Patrick
Thanks for your reply.
My guess is that temp table entries will still be in your catalog until you do a VACUUM FULL of the pg_class / pg_attribute tables.
But you should not care about these entries if these tables are vacuumed at regular intervals.
What I observed in one instance seems* to be like this - by the time I connected to the recovered database (as soon as I could), an autovacuuum has run on those catalog tables and they don't have those temp table entries. Normally, autovacuum removes dead tuples, but those temp table records are live tuples at T0. So if it was autovacuum that removed them in the recovered database, were they live or dead tuples? If they are dead, what did the deletion that made them dead?
*I would like to confirm to be 100% sure but was wondering if I can get an explanation here.
Regards
Huan