Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 187892E003D for ; Tue, 8 Apr 2008 06:55:07 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05443-07 for ; Tue, 8 Apr 2008 06:54:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by developer.postgresql.org (Postfix) with ESMTP id DF0E82E003A for ; Tue, 8 Apr 2008 06:55:02 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id A2FDD470007; Tue, 8 Apr 2008 11:55:00 +0200 (CEST) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id rGUXZY99sC6C; Tue, 8 Apr 2008 11:55:00 +0200 (CEST) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 91494470006; Tue, 8 Apr 2008 11:55:00 +0200 (CEST) Date: Tue, 8 Apr 2008 11:55:00 +0200 From: Tino Schwarze To: pgsql-admin@postgresql.org Cc: Johann Spies Subject: Re: Handling large volumes of data Message-ID: <20080408095500.GB29990@easy2.in-chemnitz.de> References: <20080408094233.GG13409@sun.ac.za> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20080408094233.GG13409@sun.ac.za> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/69 X-Sequence-Number: 28833 On Tue, Apr 08, 2008 at 11:42:34AM +0200, Johann Spies wrote: > 12501 ? S 0:00 /usr/lib/postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/main -c config_file=/etc/postgresql/8.1/main/postgresql.conf > 12504 ? D 0:54 \_ postgres: writer process > 12505 ? S 1:42 \_ postgres: stats buffer process > 12506 ? S 1:03 | \_ postgres: stats collector process > 15918 ? D 1214:28 \_ postgres: autovacuum process firewall > 18613 ? D 130:08 \_ postgres: exilog exilog 146.232.128.197(53907) SELECT > 18614 ? S 12:42 \_ postgres: exilog exilog 146.232.128.197(53908) idle > 31932 ? D 16:11 \_ postgres: exilog exilog 146.232.128.106(36547) INSERT > 10380 ? S 0:00 \_ postgres: log firewall [local] DROP TABLE waiting The drop table will wait for the autovacuum to finish. You might want to kill the autovacuum process (this doesn't do any harm, just aborts the operation so the drop table may proceed). Bye, Tino. -- „Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi) www.craniosacralzentrum.de www.forteego.de