Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5AF27B5DBD4 for ; Thu, 19 May 2011 03:00:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 03622-03 for ; Thu, 19 May 2011 06:00:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.techbaza.pl (unknown [84.205.162.156]) by mail.postgresql.org (Postfix) with SMTP id 04BDDB5DBDE for ; Thu, 19 May 2011 03:00:17 -0300 (ADT) Received: from [192.168.5.115] ([195.82.180.38]) by mail.techbaza.pl ; Thu, 19 May 2011 08:00:13 +0200 Message-ID: <4DD4B1EB.50202@techbaza.pl> Date: Thu, 19 May 2011 08:00:11 +0200 From: Piotr Czekalski Organization: TECHBAZA.PL User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; pl; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6 ThunderBrowse/3.3.2 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: column type for pdf file References: <4DD42A1C.30202@encs.concordia.ca> <4DD4301F.4010403@ulb.ac.be> <20110518210041.GF2498@hermes.hilbert.loc> <4DD43867.2040709@ulb.ac.be> <4DD47D28.3070207@postnewspapers.com.au> In-Reply-To: <4DD47D28.3070207@postnewspapers.com.au> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.792 tagged_above=-5 required=5 tests=BAYES_40=-0.001, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201105/114 X-Sequence-Number: 35398 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