Joshua D. Drake wrote:

>> SELECT oid::regclass FROM pg_class WHERE
>> reltoastrelid='pg_toast.pg_toast_49013869'::regclass;
>>
>> oid | pg_temp_24.tmp_isp_blk_chk
>>
>> The hack to get this cleaned up was to connect about 2 dozen times (to
>> get to slot 24) with psql via different sessions and create temp
>> tables. Once we hit slot 24, the probably instantly went away and the
>> database returned to normal state.

Ah -- interesting.  This is a known issue, but we haven't found a
solution yet.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

• Re: Bug: Unreferenced temp tables disables vacuum to update xid at 2008-01-07 05:59:54 from Joshua D. Drake

Responses

• Re: Bug: Unreferenced temp tables disables vacuum to update xid at 2008-01-07 16:55:09 from Joshua D. Drake

pgsql-hackers by date

Next:	From: Markus Schiltknecht	Date: 2008-01-07 12:59:01
	Subject: Re: Dynamic Partitioning using Segment Visibility Maps
Previous:	From: Csaba Nagy	Date: 2008-01-07 11:14:43
	Subject: Re: Dynamic Partitioning using Segment Visibility Maps