temp tables remain after server restart

Поиск
Список
Период
Сортировка
От Hari Bhaskaran
Тема temp tables remain after server restart
Дата
Msg-id 8d03025a050831115546bcb517@mail.gmail.com
обсуждение исходный текст
Ответы Re: temp tables remain after server restart  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Frank
Дата:
Сообщение: Re: newbie - postgresql or mysql
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: newbie - postgresql or mysql