Date: Thu, 19 May 2011 15:53:31 +0200
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: column type for pdf file
Message-ID: <20110519135331.GI2381@hermes.hilbert.loc>
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>
	<4DD4B1EB.50202@techbaza.pl> <4DD51DAA.4010706@encs.concordia.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4DD51DAA.4010706@encs.concordia.ca>
User-Agent: Mutt/1.5.21 (2010-09-15)

On Thu, May 19, 2011 at 09:39:54AM -0400, Emi Lu wrote:

> All right, it seems that everyone thinks saving a pdf into postgresql
> is not a good idea.

No.

> As a summary, disadvantages are:
> ==================================
> . Memory issue when read/save/retrieve the file
> . Increase load

Those can be a consideration, yes.

> . Consume connections

You will need a connection to the database anyway. There's
no need to use another one.

> . during transaction lo may be lost?

Huh ?

> . file systems do better than DB

That's not a fact but rather an assertion. And a partial one
at that.

You may want to search the archives a bit as this has been
discussed at length various times.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346