important Re: [HACKERS] Open 6.5 items

Поиск
Список
Период
Сортировка
От ZEUGSWETTER Andreas IZ5
Тема important Re: [HACKERS] Open 6.5 items
Дата
Msg-id 219F68D65015D011A8E000006F8590C60267B388@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы Re: important Re: [HACKERS] Open 6.5 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
    Hiroshi wrote:
> Ole Gjerde who provided the patch for current implementation of 
> mdtruncate() sayz.
> "First, please reverse my patch to mdtruncate() in md.c as soon as
>  possible.  It does not work properly in some cases."
> 
> I also recommend to reverse his patch to mdtruncate().
> 
> Though we could not shrink segmented relations by old implementation 
> the result by vacuum would never be inconsistent(?).
> 
> I think we don't have enough time to fix this.
> 
If there is no fix for vacuum, I suggest to change the filesize before
splitting
back to just below 2 Gb (2Gb - 8k). Else vacuum will only work for tables
up to 1 Gb, and it did work up to 2 Gb before.

I am the one who suggested 1 Gb, so I had my eye on this issue.
I still think 1 Gb is good for various reasons, but only if vacuum works.

Andreas


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

Предыдущее
От: Vadim Mikheev
Дата:
Сообщение: Re: [HACKERS] Open 6.5 items
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] Open 6.5 items