Re: [INTERFACES] 8k limit
От
Gene Selkov, Jr.
Тема
Re: [INTERFACES] 8k limit
Дата
Msg-id
199910270541.AAA25460@antares
Ответ на
8k limit (StOo)
Список
Дерево обсуждения
8k limit StOo <stuart@comodo.net>
Re: [INTERFACES] 8k limit "Gene Selkov, Jr." <selkovjr@mcs.anl.gov>
> Next question is whats the max number of large > objects you can store? I think its about 4 billion , am i wrong? Don't know the exact theortical limit, but I believe it depends on the capability of your file system, rather than pointer size and such, because each lo is a file. For example, my file system can have 1064960 files in it (one can find that out with fsck), but the practical constraint will be much lower. I find it difficult to deal with 30000 files in one directory, for example. The time it takes to open a file in such directory is usually on the order of seconds. --Gene
В списке pgsql-interfaces по дате отправления