X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5EFD2D8AF1 for ; Mon, 12 Sep 2005 16:57:10 -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 48320-03 for ; Mon, 12 Sep 2005 19:57:04 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 49C4CD83BD for ; Mon, 12 Sep 2005 16:57:03 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j8CJv4wS024171; Mon, 12 Sep 2005 15:57:04 -0400 (EDT) To: David Wall Cc: pgsql-interfaces@postgresql.org Subject: Re: Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB In-reply-to: <4325AA10.2050103@computer.org> References: <4325AA10.2050103@computer.org> Comments: In-reply-to David Wall message dated "Mon, 12 Sep 2005 09:17:20 -0700" Date: Mon, 12 Sep 2005 15:57:04 -0400 Message-ID: <24170.1126555024@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/17 X-Sequence-Number: 5740 David Wall writes: > Is there any reason why the vacuumlo > under 7.3 didn't remove large objects that were then removed under 8.0? [ digs in CVS logs ... ] I think vacuumlo is actually entirely broken in the 7.3 branch, because this 7.4 patch: 2002-12-09 20:57 momjian * contrib/vacuumlo/vacuumlo.c: Following patch avoids removing oids in the temporary table from the temporary table. Kenji Sugita wasn't ever back-patched. The former coding was assuming that temp tables had real names of the form "pg_temp_NNN", which is no longer true in 7.3, and the net result would be that nothing got deleted. There were some schema-awareness bugs too, but that one would render the whole thing a no-op. regards, tom lane