| From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
|---|---|
| To: | |
| Cc: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz>, pgsql-general(at)postgresql(dot)org, PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: 500KB PDF files for postgresql8.3, which is the most efficient way? |
| Date: | 2011-05-27 16:15:00 |
| Message-ID: | 4DDFCE04.2050402@encs.concordia.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Hello,
I'd like to have more comments about the following case:
> . 500KB per PDF file; 30 files per year
> . PSQL8.3
. struts2.2.3 + mybatis for sql operation
. tomcat6
Added more info
Solution:
====================
(1) Save pdfs to file system, only point file name in psql8.3
(2) Save oids of pdfs into table
(3) Save pdf files as bytea column in psql8.3
Pros and cons for (1), (2), (3), which is the most efficient way?
Thanks a lot!
Emi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-05-27 16:15:25 | Re: Is there any problem with pg_notify and memory consumption? |
| Previous Message | Per-Olov Esgard | 2011-05-27 16:12:50 | Re: Is there any problem with pg_notify and memory consumption? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel Gendler | 2011-05-27 19:28:22 | Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way? |
| Previous Message | Emi Lu | 2011-05-27 16:12:42 | 500KB PDF files for postgresql8.3, which is the most efficient way? |