| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | George Nychis <gnychis(at)cmu(dot)edu> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, 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 02:26:23 |
| Message-ID: | 20070227022623.GY19104@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
George Nychis wrote:
> 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
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-02-27 02:33:20 | Re: dropping a master table and all of its partitions? |
| Previous Message | Tom Lane | 2007-02-27 02:25:01 | Re: preventing ALTER TABLE RENAME from changing view definitions? |