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