Postgres Pro
Downloads
Home   >   mailing lists

dropping a master table and all of its partitions? - Mailing list pgsql-general

From George Nychis
Subject dropping a master table and all of its partitions?
Date
Msg-id 45E37E91.8090500@cmu.edu
Whole thread Raw
Responses Re: dropping a master table and all of its partitions?  (Erik Jones <erik@myemma.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Most efficient report of number of records in all tables?
Next
From: Erik Jones
Date:
Subject: Re: dropping a master table and all of its partitions?