From: Piotr Czekalski <pczekalski@techbaza.pl>
To: pgsql-sql@postgresql.org
Subject: Re: column type for pdf file
Date: Thu, 19 May 2011 08:00:11 +0200
Message-ID: <4DD4B1EB.50202@techbaza.pl> (raw)
In-Reply-To: <4DD47D28.3070207@postnewspapers.com.au>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pczekalski@techbaza.pl
Subject: Re: column type for pdf file
In-Reply-To: <4DD4B1EB.50202@techbaza.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox