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

George Nychis wrote:
> Sure I can do that, but why is this happening? Is this normal behavior?

Well that is the better question. If it is indeed doing what you say it
is doing, I would say it is a bug. However you have not mentioned
several important items, like what postgresql version you are running.

Joshua D. Drake

>
> - 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)
>>
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/