Re: COPY example for partial tables - Mailing list pgsql-docs

From Jim C. Nasby
Subject Re: COPY example for partial tables
Date
Msg-id 20051011233342.GR23883@pervasive.com
Whole thread Raw
In response to Re: COPY example for partial tables  (David Fetter <david@fetter.org>)
Responses Re: COPY example for partial tables
List pgsql-docs
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...
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-docs by date:

Previous
From: David Fetter
Date:
Subject: Re: COPY example for partial tables
Next
From: David Fetter
Date:
Subject: Re: COPY example for partial tables