From: Julien Cigar <jcigar@ulb.ac.be>
To: pgsql-sql@postgresql.org
Subject: Re: column type for pdf file
Date: Wed, 18 May 2011 23:21:43 +0200
Message-ID: <4DD43867.2040709@ulb.ac.be> (raw)
In-Reply-To: <20110518210041.GF2498@hermes.hilbert.loc>
References: <4DD42A1C.30202@encs.concordia.ca>
<4DD4301F.4010403@ulb.ac.be>
<20110518210041.GF2498@hermes.hilbert.loc>
On 05/18/2011 23:00, Karsten Hilbert wrote:
> On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
>
>> Unless you've good reasons to do so it's best to store the file on
>> the file system
> Why ?
>
> If you suggest reasons are needed for storing the PDF in the
> database I'd like to know the reasons for *not* doing so.
>
It increases the load, consume connections, but the biggest drawback is
probably the memory consumption ..
IMHO storing binary data in a database is almost always a bad idea .. it
could be OK to store things like avatars, small icons, etc, but
certainly not to store files of several MB ... file systems are done for
that !
> Karsten
Attachments:
[text/x-vcard] jcigar.vcf (252B, ../4DD43867.2040709@ulb.ac.be/2-jcigar.vcf)
download | inline:
begin:vcard
fn:Julien Cigar
n:Cigar;Julien
org;quoted-printable:Universit=C3=A9 Libre de Bruxelles
adr:;;;;;;Belgium
email;internet:jcigar@ulb.ac.be
tel;cell:+32 (0) 473 30 71 92
x-mozilla-html:FALSE
url:http://www.biodiversity.be
version:2.1
end:vcard
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: jcigar@ulb.ac.be
Subject: Re: column type for pdf file
In-Reply-To: <4DD43867.2040709@ulb.ac.be>
* 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