Hi,
one of our programs went haywire and created around 200,000 temp
tables. In the end, I restarted the db, but the temporary tables are
still around
the query
SELECT n.nspname, c.relname, c.relkind, c.relpages, c.reltuples FROM
pg_class c LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE
(c.relkind = 'r'::"char" OR c.relkind = 'i'::"char") order by relpages
still shows all 200,000 of them.
What should I be doing to clean it up?
They are all under pg_temp_xxxxx namespaces
Any help is appreciated.
--
Hari