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@xxxxxxxxxx <mailto:erik@xxxxxxxxxx>>
sofware developer
615-296-0838
emma(r)
