| From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way? |
| Date: | 2011-05-30 07:39:50 |
| Message-ID: | 20110530073950.GA27187@nibiru.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
* Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> 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
(4) Put them into an object store, eg. venti.
cu
--
----------------------------------------------------------------------
Enrico Weigelt, metux IT service -- http://www.metux.de/
phone: +49 36207 519931 email: weigelt(at)metux(dot)de
mobile: +49 151 27565287 icq: 210169427 skype: nekrad666
----------------------------------------------------------------------
Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme
----------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Machiel Richards | 2011-05-30 07:45:30 | determine database and tables from deadlock |
| Previous Message | Alban Hertroys | 2011-05-30 06:45:50 | Re: How to check a table content efficiently? With LIMIT and OFFSET? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2011-05-30 09:21:19 | Re: Order of evaluation in triggers for checks on inherited table partitions |
| Previous Message | Surfing | 2011-05-29 08:03:36 | Re: Function to total reset a schema |