Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way? - Mailing list pgsql-general

From Enrico Weigelt
Subject Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?
Date
Msg-id 20110530073950.GA27187@nibiru.local
Whole thread Raw
In response to 500KB PDF files for postgresql8.3, which is the most efficient way?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
* Emi Lu <emilu@encs.concordia.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@metux.de
 mobile: +49 151 27565287  icq:   210169427         skype: nekrad666
----------------------------------------------------------------------
 Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme
----------------------------------------------------------------------

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Next
From: Yan Chunlu
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?