Manuel Sugawara wrote: > In each database executed: > > select relname, age(relfrozenxid) from pg_class where relnamespace = > '10406'::oid; > > (note that 10406 is the oid of the pg_temp_1 namespace) none of them > showed temp tables, Is this the correct way?, Any other idea?.
Hmm, nope -- take away the relnamespace check, because there is a different namespace for each backend (pg_temp_2, pg_temp_3, etc). And as far as I've seen, most leftover temp tables are on "high" temp schemas (i.e. those belonging to backends that are only used when the load is high). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general