From: | George Nychis <gnychis(at)cmu(dot)edu> |
---|---|
To: | Erik Jones <erik(at)myemma(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: dropping a master table and all of its partitions? |
Date: | 2007-02-27 01:39:11 |
Message-ID: | 45E38BBF.7070502@cmu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sure I can do that, but why is this happening? Is this normal behavior?
- George
Erik Jones wrote:
> 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 <mailto:erik(at)myemma(dot)com>>
> sofware developer
> 615-296-0838
> emma(r)
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-02-27 01:45:48 | Re: dropping a master table and all of its partitions? |
Previous Message | Erik Jones | 2007-02-27 01:37:16 | Re: dropping a master table and all of its partitions? |