Re: column type for pdf file

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