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@xxxxxxxxxx <mailto:erik@xxxxxxxxxx>> >> 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/
