> > I need to store large files (from several MB to 1GB) in Postgres > > database. The database has multiple schemas. It looks like Postgres > > has 2 options to store large objects: LOB and BYTEA. However we seem > > to hit problems with each of these options. > > I believe the general consensus around here is to not do that, if you > can avoid it. File systems are much better equipped to handle files > of that magnitude, especially when it comes to retrieving them, > scanning through their contents, or really, any access pattern aside > from simple storage. > > You're better off storing the blob on disk somewhere and storing a > row that refers to its location. Either key pieces for a naming > scheme or the full path.
What's the state of implementation (planning) for this?: http://wiki.postgresql.org/wiki/DATALINK Sincerely, Wolfgang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
