Re: Orphan TOAST object

------=_Part_2286_5640225.1210603283118
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Problem has now been solved.  Thanks a lot for all your help.

On 5/12/08, Tom Lane <tgl@[EMAIL PROTECTED]
> wrote:
>
> "James Farrugia" <james.farrugia@[EMAIL PROTECTED]
> writes:
> > One last thing...can we run into data-loss problems with successfully
> > vacuumed tables even if there is one unvacuumed database object; what
> would
> > have happened if I ignored to vacuum that rogue pg_toast (which was
the
> only
> > unvacuumed object within the entire database)?
>
> The database would have shut down when you got to the
> 2-billion-transactions mark.  So you'd have had to solve the problem
> sooner or later anyway.
>
>                        regards, tom lane
>

------=_Part_2286_5640225.1210603283118
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Problem has now been solved.&nbsp; Thanks a lot for all your help.<br><br>
<div><span class="gmail_quote">On 5/12/08, <b class="gmail_sendername">Tom
Lane</b> &lt;<a href="mailto:tgl@[EMAIL PROTECTED]
">tgl@[EMAIL PROTECTED]
>&gt;
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">&quot;James Farrugia&quot; &lt;<a
href="mailto:james.farrugia@[EMAIL PROTECTED]
">james.farrugia@[EMAIL PROTECTED]
>&gt;
writes:<br>
&gt; One last thing...can we run into data-loss problems with
successfully<br>&gt; vacuumed tables even if there is one unvacuumed
database object; what would<br>&gt; have happened if I ignored to vacuum
that rogue pg_toast (which was the only<br>
&gt; unvacuumed object within the entire database)?<br><br>The database
would have shut down when you got to the<br>2-billion-transactions
mark.&nbsp;&nbsp;So you&#39;d have had to solve the problem<br>sooner or
later anyway.<br><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
regards, tom lane<br></blockquote></div><br>

------=_Part_2286_5640225.1210603283118--