Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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


In response to

Responses

pgsql-sql by date

Next:From: Samuel GendlerDate: 2011-05-27 19:28:22
Subject: Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way?
Previous:From: Emi LuDate: 2011-05-27 16:12:42
Subject: 500KB PDF files for postgresql8.3, which is the most efficient way?

pgsql-general by date

Next:From: Merlin MoncureDate: 2011-05-27 16:15:25
Subject: Re: Is there any problem with pg_notify and memory consumption?
Previous:From: Per-Olov EsgardDate: 2011-05-27 16:12:50
Subject: Re: Is there any problem with pg_notify and memory consumption?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group