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

George Nychis [EMAIL PROTECTED] writes: Here is an exact script which generates this every single time... After you're done running the ruby script: DROP TABLE testflows CASCADE; I tweaked the ruby script to emit the SQL commands into a script file, which proved to issue 1765 CREATE TABLE

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

Tom Lane wrote: George Nychis [EMAIL PROTECTED] writes: Here is an exact script which generates this every single time... After you're done running the ruby script: DROP TABLE testflows CASCADE; I tweaked the ruby script to emit the SQL commands into a script file, which proved to issue

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

George Nychis [EMAIL PROTECTED] writes: Tom Lane wrote: While neither number is exactly awe-inspiring, I'm not seeing why you think the DROP is particularly broken? Then maybe it's a bug in my version of postgresql, what version are you using? I tried it on HEAD and 8.2 and didn't see a

[GENERAL] dropping a master table and all of its partitions?

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

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

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*

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

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

Re: [GENERAL] 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

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

I tend to forget the important details ;) [EMAIL PROTECTED]:~$ psql --version psql (PostgreSQL) 8.1.8 contains support for command-line editing [EMAIL PROTECTED]:~$ 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:

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

George Nychis wrote: I tend to forget the important details ;) [EMAIL PROTECTED]:~$ psql --version psql (PostgreSQL) 8.1.8 contains support for command-line editing [EMAIL PROTECTED]:~$ uname -a Linux sn001 2.6.17-10-server #2 SMP Tue Dec 5 21:17:26 UTC 2006 x86_64 GNU/Linux Just tried

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

Joshua D. Drake [EMAIL PROTECTED] writes: 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