| From: | Dan Boitnott <dan(at)mcneese(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Large Objects |
| Date: | 2004-12-27 16:39:48 |
| Message-ID: | EC42F2F9-5825-11D9-B847-000D932E24AA@mcneese.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I need to do some investigation into the way Postgres handles large
objects for a major project involving large objects. My questions are:
* Can large objects be stored within a field value or must they be
referenced by OID?
* Are large objects backed up in the normal way or does special
action have to be taken?
* If the objects are restored or migrated will they retain their OID?
* If not, is there another means of referencing them that would be
persistent through migrations?
* Is it practical/desirable to store files MIME-Encoded inside a
text field?
* The obvious advantages:
* definitely portable across migrations and backups
* based on universal technology
* easy to code
* easy to reference and version-control
* The obvious disadvantages:
* slow, Slow, SLOW
* significant increase in per-file storage requirements
Any help would be greatly appreciated. Hope I'm posting to the right
list.
Dan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-12-27 17:02:24 | Re: 8.0 rc2 Problem |
| Previous Message | vinita bansal | 2004-12-27 16:36:21 | error : syntax error at or near $1 for over select rows |