X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8BA3FD78CB for ; Tue, 11 Oct 2005 20:49:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51369-08 for ; Tue, 11 Oct 2005 23:49:28 +0000 (GMT) Received: from fetter.org (dsl092-188-065.sfo1.dsl.speakeasy.net [66.92.188.65]) by svr1.postgresql.org (Postfix) with ESMTP id 4AA55D78A7 for ; Tue, 11 Oct 2005 20:49:30 -0300 (ADT) Received: from fetter.org (localhost.localdomain [127.0.0.1]) by fetter.org (8.13.4/8.12.10) with ESMTP id j9BNnXBG010949; Tue, 11 Oct 2005 16:49:33 -0700 Received: (from shackle@localhost) by fetter.org (8.13.4/8.13.4/Submit) id j9BNnWiI010948; Tue, 11 Oct 2005 16:49:32 -0700 Date: Tue, 11 Oct 2005 16:49:32 -0700 From: David Fetter To: "Jim C. Nasby" Cc: PostgreSQL Docs Subject: Re: COPY example for partial tables Message-ID: <20051011234932.GF6239@fetter.org> References: <20051011230217.GD6239@fetter.org> <20051011231253.GL23883@pervasive.com> <20051011232240.GE6239@fetter.org> <20051011233342.GR23883@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20051011233342.GR23883@pervasive.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.067 required=5 tests=[AWL=0.017, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/28 X-Sequence-Number: 3273 On Tue, Oct 11, 2005 at 06:33:42PM -0500, Jim C. Nasby wrote: > On Tue, Oct 11, 2005 at 04:22:40PM -0700, David Fetter wrote: > > On Tue, Oct 11, 2005 at 06:12:53PM -0500, Jim C. Nasby wrote: > > > Why the vacuum? Seems a bit sever to do a vacuum of an entire > > > database just because you created a temp table. > > > > Excess enthusiasm about reclaiming space. It doesn't really need > > to be there :) > > I think it needs to be commented on, one way or another. Better to > explain that this will slowly bloat pg_class than have a mystery > vacuum that many people have no idea why it's there... Patch fixes always welcome :) Cheers, D -- David Fetter david@fetter.org http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote!