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
Attachment:
signature.asc
Description: This is a digitally signed message part