Skip site navigation (1) Skip section navigation (2)

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

From: George Nychis <gnychis(at)cmu(dot)edu>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: dropping a master table and all of its partitions?
Date: 2007-02-27 01:48:35
Message-ID: 45E38DF3.4050705@cmu.edu (view raw or flat)
Thread:
Lists: pgsql-general
I tend to forget the important details ;)

gnychis(at)sn001:~$ psql --version
psql (PostgreSQL) 8.1.8
contains support for command-line editing
gnychis(at)sn001:~$ uname -a
Linux sn001 2.6.17-10-server #2 SMP Tue Dec 5 21:17:26 UTC 2006 x86_64 
GNU/Linux

- George


Joshua D. Drake wrote:
> 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
>>
> 
> 


In response to

Responses

pgsql-general by date

Next:From: Merlin MoncureDate: 2007-02-27 02:20:49
Subject: Re: Most efficient report of number of records in all tables?
Previous:From: Joshua D. DrakeDate: 2007-02-27 01:45:48
Subject: Re: dropping a master table and all of its partitions?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group