Re: column type for pdf file - Mailing list pgsql-sql

From Piotr Czekalski
Subject Re: column type for pdf file
Date
Msg-id 4DD4B1EB.50202@techbaza.pl
Whole thread Raw
In response to Re: column type for pdf file  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: column type for pdf file  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Right!
The external binary file storage has another advantage (that may be 
considered as disadvantage as well) - it is usually easier to develop 
and test mechanism as you're able to browse uploaded file result using 
os / application or even "exchange" file contents for test purposes, 
while in case of iternal storage you need some extra code to do it for 
you and you newer know, if it works well. Another problem is caching / 
feeding files in case of heavy load condition - caching of huge objects 
is problematic while you never know the dimension of the problem, 
non-caching approach may cause bottlenecks on frequent database reads.
I was considering both scenarios and finally've choosen external storage 
for our invoice generation system.

Regards,

Piotr



pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: column type for pdf file
Next
From: Gary Stainburn
Date:
Subject: Re: SOLVED - foreign keys and lots of tables