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 <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
>> 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/


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to