View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 10:04 AM
Tom Lane
 
Posts: n/a
Default Re: BUG #2486: PANIC when CTRL-C on vacuum full analyze

"Ronald" <lobster2@xs4all.nl> writes:
> Description: PANIC when CTRL-C on vacuum full analyze


I think we've seen this reported once before. You'd need to hit the
window where VACUUM FULL has committed its transaction but is still busy
cleaning indexes. Having moved a whole lot of rows would contribute to
making that window wider ...

I haven't looked into a fix but I imagine the best thing would be to
start a real second transaction for the cleanup phase.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote