Re: binary data storage
От | Denis Gasparin |
---|---|
Тема | Re: binary data storage |
Дата | |
Msg-id | 1018252491.2086.15.camel@edspctec12 обсуждение исходный текст |
Ответ на | Re: binary data storage (Doug McNaught <doug@wireboard.com>) |
Список | pgsql-general |
For large dimensions I mean file of 20-30 MB and up... I've noticed that when storing files of such dimensions the fetch of the objects is more and more slow... I think there is a kind of index degeneration... If anyone has tips about this problem... -- Doc. Eng. Denis Gasparin: denis@edistar.com --------------------------- Programmer & System Administrator - Edistar srl Il gio, 2002-04-04 alle 17:04, Doug McNaught ha scritto: > Denis Gasparin <denis@edistar.com> writes: > > > Hi Martin, > > I discourage you to use the large object data type for a file of such > > dimensions... It would be better for you to store in the db the filename > > and the path to the file itself. > > Why? > > > However you can find the large object you've inserted in your data > > directory (subdirectory base/oid of your database/). > > Large objects are stored in a single table, not individual files. > > -Doug > -- > Doug McNaught Wireboard Industries http://www.wireboard.com/ > > Custom software development, systems and network consulting. > Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD... > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-general по дате отправления: