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