| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Wall <d(dot)wall(at)computer(dot)org> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB |
| Date: | 2005-09-12 19:57:04 |
| Message-ID: | 24170.1126555024@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
David Wall <d(dot)wall(at)computer(dot)org> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2005-09-14 00:24:12 | Beta of DBD::Pg 1.44 available |
| Previous Message | David Wall | 2005-09-12 16:17:20 | Backup 7.3 was 19GB, restored on 8.0.3 was only 4GB |