Re: [HACKERS] Open 6.5 items

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Open 6.5 items
Дата
Msg-id 199906070133.VAA18372@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] Open 6.5 items  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы Re: [HACKERS] Open 6.5 items  (The Hermit Hacker <scrappy@hub.org>)
Re: [HACKERS] Open 6.5 items  (Ole Gjerde <gjerde@icebox.org>)
Список pgsql-hackers
> Future TODO items ?
> 
> As far as I see,there's no consensus of opinion whether we would 
> remove useless segments(I also think it's preferable if possible) or 
> we would only truncate the segments(as my trial patch does).
> 
> Only Bruce and Ole objected to my opinion and no one agreed 
> with me.
> How do other people who would use segmented relations think ?  
>   

I liked unlinking because it allowed old backends to still see the
segments if they still have open file descriptors, and new backends can
see there is no file there.  That seemed nice, but you clearly
demostrated it caused major problems.  Maybe truncation is the answer. 
I don't know, but we need to resolve this for 6.5.  I can't imagine us
focusing on this like we have in the past few weeks.  Let's just figure
out an answer.  I am on IRC now if someone can get on to discuss this. I
will even phone someone in US or Canada to discuss it.

What is it on the backend that causes some backend to think there is
another segment.  Does it just go off the end of the max segment size
and try to open another, or do we store the number of segments
somewhere. I thought it was the former in sgml() area.  I honestly don't
care if the segment files stay around if that is going to be a reliable
solution.

--  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
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Priorities for 6.6
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Priorities for 6.6