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