From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | George Nychis <gnychis(at)cmu(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: dropping a master table and all of its partitions? |
Date: | 2007-02-27 01:37:16 |
Message-ID: | 5247826F-883F-478E-B6D9-843DD4F9CAD7@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | George Nychis | 2007-02-27 01:39:11 | Re: dropping a master table and all of its partitions? |
Previous Message | George Nychis | 2007-02-27 00:42:57 | dropping a master table and all of its partitions? |