Re: column type for pdf file

On 05/19/2011 09:53 PM, Karsten Hilbert wrote:
> 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.

Hardly everyone. You lose transaction safety when using file system 
storage outside the DB, you need another way to talk to the server than 
just the Pg connection, and most importantly your backups become more 
complicated because you have two things to back up.

It's not simple, and it depends a lot on how much the data changes, how 
big the files are, etc.

--
Craig Ringer