Re: Re: bulk_multi_insert infinite loops with large rows and small fill factors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: bulk_multi_insert infinite loops with large rows and small fill factors
Дата
Msg-id 8646.1355326620@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re: bulk_multi_insert infinite loops with large rows and small fill factors  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Heikki Linnakangas <hlinnakangas@vmware.com> writes:
> The bug's been fixed now, but note that huge tuples like this will 
> always cause the table to be extended. Even if there are completely 
> empty pages in the table, after a vacuum. Even a completely empty 
> existing page is not considered spacious enough in this case, because 
> it's still too small when you take fillfactor into account, so the 
> insertion will always extend the table.

Seems like that's a bug in itself: there's no reason to reject an empty
existing page.
        regards, tom lane



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: [BUG?] lag of minRecoveryPont in archive recovery
Следующее
От: Pavan Deolasee
Дата:
Сообщение: Re: PageIsAllVisible()'s trustworthiness in Hot Standby