Re: column type for pdf file - Mailing list pgsql-sql

From Karsten Hilbert
Subject Re: column type for pdf file
Date
Msg-id 20110519135331.GI2381@hermes.hilbert.loc
Whole thread Raw
In response to Re: column type for pdf file  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: column type for pdf file  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: column type for pdf file
Next
From: Craig Ringer
Date:
Subject: Re: column type for pdf file