Skip site navigation (1) Skip section navigation (2)

Re: Orphan TOAST object

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James Farrugia" <james(dot)farrugia(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Orphan TOAST object
Date: 2008-05-12 14:08:55
Message-ID: 18954.1210601335@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"James Farrugia" <james(dot)farrugia(at)gmail(dot)com> 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

In response to

Responses

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2008-05-12 14:24:38
Subject: Re: how to get a number of seconds in some interval ?
Previous:From: Julius TuskenisDate: 2008-05-12 13:44:16
Subject: how to get a number of seconds in some interval ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group