Re: Fix for large file support

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fix for large file support
Дата
Msg-id 14547.1175879048@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Fix for large file support  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Ответы Re: Fix for large file support
Список pgsql-patches
Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> Andrew Dunstan wrote:
>> Or give better performance?

> Yes. List of chunks is stored as linked list and for some operation
> (e.g. expand) are all chunks opened and their size is checked. On big
> tables it takes some time. For example if you have 1TB big table and you
> want to add new block you must go and open all 1024 files.

Indeed, but that would be far more effectively addressed by fixing the
*other* code path that doesn't segment at all (the
LET_OS_MANAGE_FILESIZE option, which is most likely broken these days
for lack of testing).  I don't see the point of a halfway measure like
increasing RELSEG_SIZE.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Packed Varlena Update (v21)
Следующее
От: Zdenek Kotala
Дата:
Сообщение: Re: Fix for large file support