Up to now, to store large objects i used the bytea data type. I experienced this without problem with objects of size of some tens of KBytes, without specifying any options.
Now, i plan to store much larger objects (tens of MBytes). After reading the documentation, it seems that i have two options:
- use the option WITH OIDS during CREATE TABLE or ALTER TABLE
or
- use the large objects capabilities supplied by postgreSQL.
Is it a good idea to store such large objects in DB? and if so, what is the best choice?
I work with postgresSQL 9.4.1, .net and C# under windows.