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

George Nychis wrote:
> I tend to forget the important details ;)
>
> gnychis@sn001:~$ psql --version
> psql (PostgreSQL) 8.1.8
> contains support for command-line editing
> gnychis@sn001:~$ 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 it here, worked without a hitch.

create a table "parent", then 2000 children
for i in `seq 1 2000`; do psql -c "create table child_$i (b int) inherits (parent)"; done

then
DROP TABLE parent CASCADE

and it took some seconds.  I have 1 GB of physical RAM here.

You're going to give us a lot more details ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.