| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | emilu(at)encs(dot)concordia(dot)ca |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pdf saving into DB vs. saving file location ? |
| Date: | 2011-03-23 20:10:59 |
| Message-ID: | 1300911059.2521.11.camel@lenovo01-laptop03.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2011-03-23 at 16:01 -0400, Emi Lu wrote:
>
> A question about saving PDF (size around 160kb) into postgresql large
> object columns vs. saving into a directory.
>
> May I know the performance differences? Pros and crons please?
>
> Each year, 20 new pdfs will be saved into DB (each around 160KB).
This question *might* make sense if you were storing 200 new PDFs per
day.
OS will probably cache the PDFs if you are serving it much enough.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2011-03-23 20:17:45 | Re: pdf saving into DB vs. saving file location ? |
| Previous Message | Bill Moran | 2011-03-23 20:05:44 | Re: pdf saving into DB vs. saving file location ? |