Re: Bug: Unreferenced temp tables disables vacuum to update xid

On 2008-01-07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The real question that Josh's report brings up to me is why the heck was
> there an orphaned temp table?  Especially if it was only a toast table
> and not the linked "regular" temp table?  Something happened there that
> should not have.

The regular table was there too, but the regular table's relfrozenxid
was apparently recent, only the toast table's was old:

> pg_toast_49013869 | 2146491285
[...]
> SELECT oid::regclass FROM pg_class WHERE
> reltoastrelid='pg_toast.pg_toast_49013869'::regclass;
>   
> oid | pg_temp_24.tmp_isp_blk_chk

The regular table had not shown up on a query of age(relfrozenxid) WHERE
relkind='r' but the toast table showed up on a similar query with WHERE
relkind='t'.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services