X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 88DFFD1DABB for ; Mon, 17 Nov 2003 14:43:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82740-04 for ; Mon, 17 Nov 2003 10:42:44 -0400 (AST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 2D07AD1D8AE for ; Mon, 17 Nov 2003 10:42:40 -0400 (AST) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1ALkaS-0001jz-00 for ; Mon, 17 Nov 2003 09:42:44 -0500 Received: by dba2 (Postfix, from userid 1019) id 0063ACBB8; Mon, 17 Nov 2003 09:42:43 -0500 (EST) Date: Mon, 17 Nov 2003 09:42:43 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: INSERT extremely slow with large data sets (fwd) Message-ID: <20031117144243.GE1716@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20031115131338.90329.qmail@web80208.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20031115131338.90329.qmail@web80208.mail.yahoo.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/134 X-Sequence-Number: 4694 On Sat, Nov 15, 2003 at 05:13:38AM -0800, George Essig wrote: > > VACUUM ANALYZE will reclaim disk space and update statistics used Strictly speaking, it does not reclaim disk space. It merely marks it as available, assuming you have enough room in your free space map. VACUUM FULL reclaims disk space, i.e. it compacts the data files and returns that space to the operating system. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110