View Single Post

   
  #5 (permalink)  
Old 04-15-2008, 09:54 PM
Tom Lane
 
Posts: n/a
Default Re: 2PC-induced lockup

tomas@tuxteam.de writes:
> On Tue, Jul 10, 2007 at 10:41:31AM -0400, Tom Lane wrote:
>> Right offhand, clearing pg_twophase while the system is stopped should
>> be safe enough.


> It might make sense then to clear the pg_twophase directory on DB
> startup.


<blink> I fear you have 100% misunderstood the point. The *only*
reason for that feature is to survive DB crashes.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote