dropping a master table and all of its partitions?

Поиск
Список
Период
Сортировка
От George Nychis
Тема dropping a master table and all of its partitions?
Дата
Msg-id 45E37E91.8090500@cmu.edu
обсуждение исходный текст
Ответы Re: dropping a master table and all of its partitions?  (Erik Jones <erik@myemma.com>)
Список pgsql-general
Hey everyone,

I created a master table, and created ~2000 partitions for it.

*no* data is in any of these partitions.

I am trying to drop the master and all of the partitions with a cascade:
DROP TABLE master CASCADE;

Except after about 30 seconds my memory usage (4GB) jumps to 99%, and
after about 10 minutes it kills over and drops my connection.

How do you delete a master and all of its partitions?

Thanks!
George

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Most efficient report of number of records in all tables?
Следующее
От: Erik Jones
Дата:
Сообщение: Re: dropping a master table and all of its partitions?