Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id CEF8C2E003A for ; Tue, 8 Apr 2008 09:16:10 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67115-07 for ; Tue, 8 Apr 2008 09:16:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail3.sun.ac.za (mail3.sun.ac.za [146.232.64.13]) by developer.postgresql.org (Postfix) with ESMTP id 92BBD2E0035 for ; Tue, 8 Apr 2008 09:16:07 -0300 (ADT) Received: from werkesel.sun.ac.za ([146.232.129.30]) by mail3.sun.ac.za with esmtp (Exim 4.34) id 1JjCk7-0006zB-PC for pgsql-admin@postgresql.org; Tue, 08 Apr 2008 14:16:03 +0200 Received: from js by werkesel.sun.ac.za with local (Exim 4.69) (envelope-from ) id 1JjCk7-0000Fp-P9 for pgsql-admin@postgresql.org; Tue, 08 Apr 2008 14:16:03 +0200 Date: Tue, 8 Apr 2008 14:16:03 +0200 From: Johann Spies To: pgsql-admin@postgresql.org Subject: Re: Handling large volumes of data Message-ID: <20080408121603.GV13409@sun.ac.za> Mail-Followup-To: Johann Spies , pgsql-admin@postgresql.org References: <20080408094233.GG13409@sun.ac.za> <20080408095500.GB29990@easy2.in-chemnitz.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20080408095500.GB29990@easy2.in-chemnitz.de> User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/74 X-Sequence-Number: 28838 On Tue, Apr 08, 2008 at 11:55:00AM +0200, Tino Schwarze wrote: > 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). Thanks. That is good to know. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "Be careful for nothing; but in every thing by prayer and supplication with thanksgiving let your requests be made known unto God. And the peace of God, which passeth all understanding, shall keep your hearts hearts and minds through Christ Jesus." Philippians 4:6,7