Re: [HACKERS] tables > 1 gig

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] tables > 1 gig
Дата
Msg-id 199906180532.BAA17134@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] tables > 1 gig  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы RE: [HACKERS] tables > 1 gig  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
> > Yes, I can see your point.  It would show them different views of the
> > table.
> >
> > So, as you were saying, we have no way of invalidating file descriptors
> > of other backends for secondary segments.
> 
> It seems DROP TABLE has a similar problem.
> It has been already solved ?

Not solved.  Someone reported it recently.

> 
> > Why does truncating the file
> > not work?  Any ideas?
> >
> 
> I have gotten no bug reports for my trial implementation.
> AFAIK,only Ole Gjerde has tested my patch.
> Is it sufficient ?

Yes.  We need something, and maybe after we add it, people can do
testing and find any problems.  It is better to apply it than to leave
it as it currently exists, no?

--  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 по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] tables > 1 gig
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] tables > 1 gig