Re: dropping a master table and all of its partitions?

Did you use some kind of sensical naming convention for the child
tables? If so, couldn't you write a script to loop through and drop
them one at a time?

On Feb 26, 2007, at 6:42 PM, George Nychis wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/

erik jones <erik(at)myemma(dot)com>
sofware developer
615-296-0838
emma(r)