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

Re: Bug: Unreferenced temp tables disables vacuum toupdate xid

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug: Unreferenced temp tables disables vacuum toupdate xid
Date: 2008-01-07 12:18:24
Message-ID: 20080107121824.GA4723@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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

Responses

pgsql-hackers by date

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

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