Re: [HACKERS] Open 6.5 items

> I couldn't explain more because of my poor English,sorry.
> 
> But my test case usually causes backend abort.
> My test case is
>     While 1 or more sessions frequently insert/update a table,
>     vacuum the table.
> 
> After vacuum, those sessions abort with message 
>     ERROR:  cannot open segment .. of relation ...
> 
> This ERROR finally causes spinlock freeze as I reported in a posting
> [HACKERS] spinlock freeze ?(Re: INSERT/UPDATE waiting (another 
> example)). 
> 
> Comments ?

OK, I buy that.  How will truncate fix things?  Isn't that going to be
strange too.  Hard to imagine how we are going to modify these things. 
I am now leaning to the truncate option, especially considering that
usually only the last segment is going to be truncated.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026