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

From Emi Lu
Subject Re: 500KB PDF files for postgresql8.3, which is the most efficient way?
Date
Msg-id 4DDFCE04.2050402@encs.concordia.ca
Whole thread Raw
In response to copy record?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way?  (Samuel Gendler <sgendler@ideasculptor.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Carlos Sotto Maior \(SIM\)"
Date:
Subject: SELECT COUNT(*) execution time on large tables (v9.0.4-1)
Next
From: Emi Lu
Date:
Subject: 500KB PDF files for postgresql8.3, which is the most efficient way?