RE: [HACKERS] Open 6.5 items

> 
> > > I thought we decided that file descriptors are kept by 
> backends, and are
> > > still accessable while new backends don't see the files.  Correct?
> > >
> > 
> > Yes,other backends could write to unliked files which would be 
> > vanished before long.
> > I think it's more secure to truncate useless segments to size 0 
> > than unlinking the segments though vacuum would never remove 
> > useless segments.
> 
> If you truncate, other backends will see the data gone, and will be
> writing into the middle of an empty file.  Better to remove.
>

I couldn't explain more because of my poor English,sorry.

But my test case usually causes backend abort.
My test case isWhile 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 ?

Thanks.

Hiroshi Inoue
Inoue@tpf.co.jp