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

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
(view: Whole thread, Raw)
In response to: 500KB PDF files for postgresql8.3, which is the most efficient way?  (Emi Lu)
List: pgsql-general

Tree view

copy record?  ("Gauthier, Dave", )
 Re: copy record?  ("Gauthier, Dave", )
  Re: copy record?  (Bosco Rama, )
 Re: copy record?  (Jasen Betts, )
  500KB PDF files for postgresql8.3, which is the most efficient way?  (Emi Lu, )
   Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?  (Enrico Weigelt, )
 Re: copy record?  (Merlin Moncure, )
 Re: 500KB PDF files for postgresql8.3, which is the most efficient way?  (Emi Lu, )
  Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way?  (Samuel Gendler, )

* Emi Lu <> 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: 
 mobile: +49 151 27565287  icq:   210169427         skype: nekrad666
----------------------------------------------------------------------
 Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme
----------------------------------------------------------------------


pgsql-general by date:

From: Alban Hertroys
Date:
Subject: Re: Re : Update columns in same table from update trigger?
From: Sim Zacks
Date:
Subject: Re: Update columns in same table from update trigger?