Re: binary data storage

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