Re: column type for pdf file

From: Piotr Czekalski <pczekalski(at)techbaza(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: column type for pdf file
Date: 2011-05-19 06:00:11
Message-ID: 4DD4B1EB.50202@techbaza.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2011-05-19 08:38:47 Re: SOLVED - foreign keys and lots of tables
Previous Message Craig Ringer 2011-05-19 02:15:04 Re: column type for pdf file